dữ liệu Nhãn tab Cho phép bạn để hiển thị các giá trị dữ liệu và nhãn với hàng loạt dữ có thể hiển thị các giá trị như tỷ lệ phần trăm hoặc trong các đơn vị của giá trị bản thânTùy chọn tab Đối với một chuỗi dữ liệu cột, tab này cho phép bạn để chồng lên nhau series và thiết lập | CHAPTER 15 Automate with Macros 369 NOTE The first argument in the DateAdd function yyyy indicates that the interval you want to increment is the year part of the date value. The second argument is the number to add the third names the control that contains the original date. Set Control Properties You can set many of the properties of forms reports and controls by running a macro. For example you can hide a control from view on the form or disable it so the user can t enter data in it. You can also change colors fonts and other appearance properties. As an example of setting a property with a macro disable the Drivers License control if the subject of the Alpha Card report is younger than 16. To do this set the Enabled property to No. When a control is disabled it still appears on the screen but is dimmed you can t reach it by pressing TAB or by clicking it. To ensure that you enter the correct identifier you can use the Expression Builder. After adding the SetValue action to the macro click Build . next to the Item argument to open the Expression Builder then do the following 1. Double-click on the Forms folder then double-click on the All Forms folder in the left panel to open the list of forms in the current database. 2. Choose the Alpha Card form. A list of all controls and labels in the form appears in the center panel. 3. Choose Drivers License. A list of all the properties that apply to the Drivers License text box control appears in the right panel. 4. Choose Enabled and click Paste. When you click OK the expression is placed in the Item argument box. 15 To complete the macro 1. Enter No in the Expression argument. 2. Add a condition to the Action row that runs the macro only if the Age value is less than 16. 370 How to Do Everything with Microsoft Office Access 2003 TIP 3. Attach the macro to the Age control s After Update event property. You probably will want to add another macro to reenable the Drivers License when you move to the next record. If you .
