Form, Query, Table.
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.
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.
Changes to the DatasheetGridLinesBehavior property will only be visible if the DatasheetCellsEffect property is set to Flat.
DatasheetCellsEffect Property, DatasheetGridLinesColor Property.