Microsoft Office Tutorials and References
In Depth Information
Taking Control of Your Form or Report
1. If the property sheet isn’t already visible, display it by clicking the
Property Sheet button in the Tools group on the Design tab of the
You see the property sheet, as shown in Figure 2-4.
of a text box
2. On the form, click the control whose properties you want to change.
The property sheet shows the properties for that control.
3. Find and change the appropriate property.
Finding the property is the hardest part. You can guess which tab it’s
on, or you can click the All tab and scan the whole list. Wouldn’t it be
nice if Access listed the properties in alphabetical order to make them
easier to find?
Advanced form designers can make macros or VBA modules run when users
move the cursor in or out of the controls on the form. To connect a VBA
module or macro to a form (or to a control on the form, like a button), you
set a property on the Events tab of the property sheet. It’s not hard! See
Book VI for details on creating macros and connecting them to form events.
Book VIII discusses creating VBA modules for forms.
Binding a control to data in the record source
The most important property of most controls is Control Source, which
tells Access what information to display in the control. The Control
Source property usually is a field in a table or query that’s the record