Adjusting Form Properties

From NeoWiki

Revision as of 00:28, 20 September 2007

Sometimes after you have designed a form, you discover that some of the form properties that you set in the wizard need to be adjusted. Other times, you may create a form in design view, without using the wizard at all, and need to set the form properties.

In the case of our birding database, I realized that when entering data on a field trip, it would be most helpful if the "Field Trips Data Entry" form pulled up with an empty form, rather than with data from a previous trip. To do this means changing the field properties.

Because I would like to also view existing data in the same format, we will first copy the form. To do so, right-click or control-click on the Field Trips Data Entry form and choose Copy. Then right-click or control-click on any blank area in the Forms section of the main database window and select Paste from the contextual menu. You will be asked to give the new form a name. I chose "Field Trips Data Viewing."

Changing Form Properties

1. Right-click or control-click on the Field Trips Data Entry icon and choose Edit
2. Click on any element of the form (a field or a label)
3. Now click on the Form icon on the toolbar (circled in red in the image below)

   

   Note that this button will be greyed out unless an element of the form has been selected. You can also access Form Properties by right-clicking or control-clicking on a form element and choosing Form.

4. Under the General Tab you may change the name if you like. Nothin else here needs to be changed.
5. Click on the Data Tab
6. Note that you can set many properties of the form here, including what type of content (Table, Query, or SQL Command), which Table or Query it relates to, etc. Search the online help for more details on many of these settings
7. Allow Additions specifies whether or not you can add records. We want to leave this set for Yes. (If you wanted a read-only form, you would set it to No
8. Allow Modifications specifies whether or not the form can be modified. Leave this set for Yes
9. Similarly, Allow Deletions should be left at Yes. (For other purposes, however, setting this to No helps to protect your data.
10. Add Data only should be set to Yes
11. The Events tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.
12. Close the Form Properties window.
13. Turn Design Mode off by clickin on the blue drafting triangle. Verify that:

• • the "Next Record" and "Previous Record" buttons are dimmed.
  • you can add Data