Form.DatasheetGridlinesBehavior Property

Access Developer Reference

You can use the DatasheetGridlinesBehavior property to specify which gridlines will appear in Datasheet view. Read/write Byte.

Syntax

expression.DatasheetGridlinesBehavior

expression   A variable that represents a Form object.

Remarks

This DatasheetGridlinesBehavior property applies only to objects in Datasheet view.

This property is only available in Visual Basic within a Microsoft Access database.

The DatasheetGridlinesBehavior property uses the following settings.

Visual Basic Description
acGridlinesNone No gridlines are displayed.
acGridlinesHoriz Only horizontal gridlines are displayed.
acGridlinesVert Only vertical gridlines are displayed.
acGridlinesBoth (Default) Horizontal and vertical gridlines are displayed.

The following table contains the properties that don't exist in the DAO Properties collection of until you set them by using the Formatting (Datasheet) toolbar or you can add them in an Access database by using the CreateProperty method and append it to the DAO Properties collection.

DatasheetFontItalic

*

DatasheetForeColor

*

DatasheetFontHeight

*

DatasheetBackColor

DatasheetFontName

*

DatasheetGridlinesColor

DatasheetFontUnderline

*

DatasheetGridlinesBehavior

DatasheetFontWeight

*

DatasheetCellsEffect

Bb237442.vs_note(en-us,office.12).gif  Note
When you add or set any property listed with an asterisk, Microsoft Access automatically adds all the properties listed with an asterisk to the Properties collection in the database.

See Also