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 *.
|
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.
|
