If you thought controls had lots of properties, wait until you see how many properties forms and reports have! Table 7-5 is another "cheat sheet" that lists the various form properties. Some of the most important properties are marked with a *.
Table 7-5. Important Form Properties
Displays a descriptive caption in the form's title bar.
Default View *
Determines the view the form is in when opened.
Single Form: Displays one record at a time.
Continuous Forms: Displays multiple records in a form.
Datasheet: Displays multiple records in a Datasheet.
PivotTable: Dynamically analyzes data, summarizes into a table.
PivotChart: Dynamically analyzes data, summarizes into a chart.
Allow Form View
Allow Datasheet View
Allow PivotTable View
Allow PivotChart View
Determines if users can switch to this view.
Scroll Bars *
Determines whether scroll bars appear on the form.
Record Selectors *
Determines whether a form contains a record selector.
Navigation Buttons *
Determines whether a form has navigation buttons.
Determines if lines appear between records in continuous forms.
Resizes the form automatically to display a complete record.
Border Style *
Determines the type of window the form appears in: None, Thin, Sizable, or Dialog.
Determines if a control menu appears in the form.
Min Max Buttons
Determines if minimize and/or maximize buttons appear in the form.
Determines if a close button appears on the form.
Determines the width of the form.
Determines the height of the form.
Adds a graphic or picture for the form or report background. Click the Build button to browse for the folder and file.
Determines if the picture is embedded or linked.
Picture Size Mode
Determines how the contents of a picture frame are displayed: Clip, Stretch, or Zoom.
Determines the alignment of a picture within a frame.
Determines whether a picture is tiled within a frame.
Determines the number of subdivisions (horizontal) in a grid.
Determines the number of subdivisions (vertical) in a grid.
Layout for Print
Determines whether the form uses printer fonts.
Specifies the path and file name for the graphic file used as a palette.
Record Source *
Specifies the table or query whose data will be used in the form.
Specifies a filter that is loaded automatically with the Form/Report.
Specifies a sort order that is loaded automatically with the Form/Report.
Determines whether filters may be applied to the form.
Allow Edits *
Determines whether records can be modified in the form.
Allow Deletions *
Determines whether records can be deleted in the form.
Allow Additions *
Determines whether records can be added in the form.
Data Entry *
Allows you to select "Yes" if you only want to use the form to add new records.
Allows you to assign a macro or Visual Basic procedure to a specific event, such as when you click or update a control.
Determines whether the form appears in a pop-up window that remains on top of all other windows.
Determines whether the form keeps the focus (you can't switch to any other windows or forms) until it is closed.
Determines how the tab key should cycle.
Allows you to select a custom menu bar that you created that should appear when the form is active.
Allows you to select a custom toolbar that you created that should appear when the form is active.
Determines if right mouse button shortcut menus are permitted in the form.
Shortcut Menu Bar
Specifies a user-created shortcut menu that appears when a user clicks the right-mouse button.
Fast Laser Printing
Print the form using optimized laser-printer formatting.
Specifies the name of the custom Help file for the form.
Help Context Id
Specifies an identifier number for a user-created Help file that appears when the user selects the control and presses F1.
Specifies extra user-defined information that is stored in the form.
Specifies if the form has Visual Basic code behind it.