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
Property | Tab | Description |
---|
Caption * | Format | Displays a descriptive caption in the form's title bar. |
Default View * | Format | 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 | Format | Determines if users can switch to this view. |
Scroll Bars * | Format | Determines whether scroll bars appear on the form. |
Record Selectors * | Format | Determines whether a form contains a record selector. |
Navigation Buttons * | Format | Determines whether a form has navigation buttons. |
Dividing Lines | Format | Determines if lines appear between records in continuous forms. |
Auto Resize | Format | Resizes the form automatically to display a complete record. |
Border Style * | Format | Determines the type of window the form appears in: None, Thin, Sizable, or Dialog. |
Control Box | Format | Determines if a control menu appears in the form. |
Min Max Buttons | Format | Determines if minimize and/or maximize buttons appear in the form. |
Close Button | Format | Determines if a close button appears on the form. |
Width * | Format | Determines the width of the form. |
Height * | Format | Determines the height of the form. |
Picture | Format | Adds a graphic or picture for the form or report background. Click the Build button to browse for the folder and file. |
Picture Type | Format | Determines if the picture is embedded or linked. |
Picture Size Mode | Format | Determines how the contents of a picture frame are displayed: Clip, Stretch, or Zoom. |
Picture Alignment | Format | Determines the alignment of a picture within a frame. |
Picture Tiling | Format | Determines whether a picture is tiled within a frame. |
Grid X | Format | Determines the number of subdivisions (horizontal) in a grid. |
Grid Y | Format | Determines the number of subdivisions (vertical) in a grid. |
Layout for Print | Format | Determines whether the form uses printer fonts. |
Palette Source | Format | Specifies the path and file name for the graphic file used as a palette. |
Record Source * | Data | Specifies the table or query whose data will be used in the form. |
Filter | Data | Specifies a filter that is loaded automatically with the Form/Report. |
Order By | Data | Specifies a sort order that is loaded automatically with the Form/Report. |
Allow Filters | Data | Determines whether filters may be applied to the form. |
Allow Edits * | Data | Determines whether records can be modified in the form. |
Allow Deletions * | Data | Determines whether records can be deleted in the form. |
Allow Additions * | Data | Determines whether records can be added in the form. |
Data Entry * | Data | Allows you to select "Yes" if you only want to use the form to add new records. |
Event Tab | Event | Allows you to assign a macro or Visual Basic procedure to a specific event, such as when you click or update a control. |
Pop Up | Other | Determines whether the form appears in a pop-up window that remains on top of all other windows. |
Modal | Other | Determines whether the form keeps the focus (you can't switch to any other windows or forms) until it is closed. |
Cycle | Other | Determines how the tab key should cycle. |
Menu Bar | Other | Allows you to select a custom menu bar that you created that should appear when the form is active. |
Toolbar | Other | Allows you to select a custom toolbar that you created that should appear when the form is active. |
Shortcut Menu | Other | Determines if right mouse button shortcut menus are permitted in the form. |
Shortcut Menu Bar | Other | Specifies a user-created shortcut menu that appears when a user clicks the right-mouse button. |
Fast Laser Printing | Other | Print the form using optimized laser-printer formatting. |
Help File | Other | Specifies the name of the custom Help file for the form. |
Help Context Id | Other | Specifies an identifier number for a user-created Help file that appears when the user selects the control and presses F1. |
Tag | Other | Specifies extra user-defined information that is stored in the form. |
Has Module | Other | Specifies if the form has Visual Basic code behind it. |