QUICKSTEPS: Keeping Data Safe Prevent User Access to Data in a Form
If you don’t want the user to be able to get to a text box control in a form by pressing TAB: - Open the form in Design view.
- Double-click the text box control you want to protect.
- In the property sheet, click the Other tab.
- Select the Tab Stop property, and choose No from the drop-down list. Then save the form design.
The user will still be able to click in the control and edit the contents. 
Limit To Values in a Lookup Field
A lookup field can appear in a form as a combo box or as a list box from which the user chooses a value. She may also enter a value not already on the list. If you don’t want other values in the field: - Open the table in Design view.
- Select the lookup fi eld in the upper pane.
- Click the Lookup tab in the lower pane, and change the Limit To List property to Yes.
- Save the table design.
Require Valid Data
To make sure newly entered data is correct, include data validation rules in a table or form design. To do this: - Open the table in Design view and select the field name in the upper pane.
- Select the Validation Rule property in the Field Properties pane, and enter the expression that the field value must comply with.
- Select the Validation Text property text box, and enter a message to display when the rule is broken.
- Save the table design.
Text box controls in forms also have the Validation Rule and Text properties. See Chapter 3 for more information on using data validation. Prevent Data Changes in a Form
To keep a user from entering, deleting, or editing data in a form: - Open the form in Design view, and double-click the form selector.
- In the property sheet, click the Data tab.
- Select the Allow Edits property text box, and choose No from the drop-down list.
- Repeat Step 3 to set the Allow Deletions and Allow Additions properties.
- Save the form design.
|
