MS Access

Form and Report Property Reference

If you thought controls had lots of properties, wait until you see how many properties forms and reports have! Table is another "cheat sheet" that lists the various form properties. Some of the most important properties are marked with a *.

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.


by BrainBellupdated
Advertisement: