ACC95: List of New Form Events and Properties in MS Access 95

• Microsoft Access version 7.0

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

This article lists the new events and properties for forms in Microsoft Access for Windows 95 version 7.0.

MORE INFORMATION

Name                    Applies To    Type       Description

ActiveControl              Form       Property   Refers to the object that
                                                 has the focus on the form.

AllowAdditions             Form       Property   Specifies whether a user
                                                 can add a record using a
                                                 form.

AllowDeletions             Form       Property   Specifies whether a user
                                                 can delete a record using
                                                 a form.

AllowEdits                 Form       Property   Specifies whether a user
                                                 can edit saved records
                                                 using a form.

CloseButton                Form       Property   Specifies whether the
                                                 Close button on a form is
                                                 enabled.

CurrentRecord              Form       Property   Identifies the current
                                                 record in the recordset
                                                 being viewed on a form.

CurrentSectionLeft         Form       Property   Determines the distance
                                                 from the left edge of the
                                                 current section to the
                                                 left edge of the form.
                                                 This is measured in twips.

CurrentSectionTop          Form       Property   Determines the distance
                                                 from the top edge of the
                                                 current section to the top
                                                 edge of the form. This is
                                                 measured in twips.

Cycle                      Form       Property   Specifies what happens
                                                 when you press the TAB key
                                                 in the last control on a
                                                 bound form.

DataEntry                  Form       Property   Specifies whether a bound
                                                 form opens to allow data
                                                 entry only.

DatasheetBackColor         Form       Property   Specifies which color to
                                                 use for the background in
                                                 Datasheet view.

DatasheetCellsEffect       Form       Property   Specifies whether special
                                                 effects are applied to
                                                 cells in a datasheet.

DatasheetForeColor         Form       Property   Specifies which color to
                                                 use for the font in
                                                 Datasheet view.

DatasheetGridlinesBehavior Form       Property   Specifies which grid lines
                                                 appear in Datasheet view.

DatasheetGridlinesColor    Form       Property   Specifies the color of
                                                 grid lines in a datasheet.

DividingLines              Form       Property   Specifies whether dividing
                                                 lines will separate
                                                 sections on a form or
                                                 whether records will be
                                                 displayed on a continuous
                                                 form.

Filter                     Form       Property   Specifies how you want to
                                                 filter a form.

FilterOn                   Form       Property   Specifies whether the
                                                 Filter property for the
                                                 form or report is applied
                                                 when the form or report is
                                                 opened.

FrozenColumns              Form       Property   Determines the number of
                                                 columns in a datasheet
                                                 that are frozen.

HasContinued               All        Property   Determines if the current
                           Sections              section is continued
                                                 from previous page.

InSelection                All        Property   Determines if an object/
                           Sections              section is in the current
                                                 selection in Design view.

InsideHeight               Form       Property   Determines the height of
                                                 the window containing the
                                                 form.

InsideWidth                Form       Property   Determines the width of
                                                 the window containing the
                                                 form.

KeyPreview                 Form       Property   Specifies whether form
                                                 keyboard events are
                                                 invoked before control
                                                 keyboard events.

LogicalPageWidth           Form       Property   The width of the printable
                                                 page less the margins.
                                                 This is measured in twips.

MinMaxButtons              Form       Property   Specifies whether Maximize
                                                 or Minimize buttons are
                                                 available on a form.

NewRecord                  Form       Property   Determines whether the
                                                 current record is a new
                                                 record.

OnApplyFilter              Form       Event      Specifies the event that
                                                 will occur when a filter
                                                 is applied to a form.

OnFilter                   Form       Event      Specifies the event that
                                                 will occur initially when
                                                 a filter is being created
                                                 for a form.

OrderBy                    Form       Property   Specifies how you want to
                                                 sort records in a form,
                                                 query, report, or table.

OrderByOn                  Form       Property   Specifies whether an
                                                 object's OrderBy property
                                                 setting is applied.

Picture                    Form       Property   Specifies a bitmap to be
                                                 displayed on a form.

PictureAlignment           Form       Property   Specifies where a
                                                 background picture
                                                 appears in an image
                                                 control or on a form or
                                                 report.

PictureSizeMode            Form       Property   Specifies how a picture
                                                 for a form or report is
                                                 sized.

PictureTiling              Form       Property   Specifies whether a
                                                 background picture is
                                                 tiled across the entire
                                                 image control, form
                                                 window, form, or page of a
                                                 report.

PictureType                Form       Property   Specifies whether an
                                                 object's picture is
                                                 saved as a linked object
                                                 or an embedded object.

RecordsetType              Form       Property   Replaces the AllowUpdating
                                                 property found in
                                                 Microsoft Access 2.0.

SelHeight                  Form       Property   Specifies the number of
                                                 rows (records) in
                                                 selection rectangle.

SelLeft                    Form       Property   Specifies which column is
                                                 leftmost in the selection
                                                 rectangle.

SelTop                     Form       Property   Specifies which row
                                                 (record) is topmost in the
                                                 selection rectangle.

SelWidth                   Form       Property   Specifies the number of
                                                 selected columns (fields)
                                                 in the selection
                                                 rectangle.

ShortcutMenuBar            Form       Property   Specifies the Menubar
                                                 macro to use to display a
                                                 shortcut menu when you
                                                 right click a form or
                                                 control.

WhatsThisButton            Form       Property   Specifies whether a help
                                                 button is added to a
                                                 form's title bar.

WillContinue               All        Property   Determines when a section
                           Sections              will continue on the next
                                                 page.

REFERENCES