DatasheetGridLinesBehavior Property

Applies To

Form, Query, Table.

Description

You can use the DatasheetGridLinesBehavior property to specify which grid lines will appear in Datasheet view.

Note This DatasheetGridLinesBehavior property applies only to objects in Datasheet view.

Setting

The DatasheetGridLinesBehavior property uses the following settings.

Setting Description Visual Basic Value
Both (Default) Horizontal and vertical grid lines are displayed. acGridLinesBoth 0
Horizontal Only horizontal grid lines are displayed. acGridLinesHoriz 1
Vertical Only vertical grid lines are displayed. acGridLinesVert 2
None No grid lines are displayed. acGridLinesNone 3


You can set this property using the Formatting toolbar (in Datasheet view), a macro, or Visual Basic.

You can also set this property by choosing Cells from the Format menu.

You can set the default DatasheetGridLinesBehavior property using the Datasheet tab of the Options dialog on the Tools menu.

Remarks

Changes to the DatasheetGridLinesBehavior property will only be visible if the DatasheetCellsEffect property is set to Flat.

See Also

DatasheetCellsEffect Property, DatasheetGridLinesColor Property.