DatasheetGridlinesBehavior Property

Applies To   Form object, QueryDef object, TableDef object.

Description

You can use the DatasheetGridlinesBehavior property to specify which gridlines 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

None

No gridlines are displayed.

acGridlinesNone

0

Horizontal

Only horizontal gridlines are displayed.

acGridlinesHoriz

1

Vertical

Only vertical gridlines are displayed.

acGridlinesVert

2

Both

(Default) Horizontal and vertical gridlines are displayed.

acGridlinesBoth

3


You can set this property by using the Gridlines button on the Formatting (Datasheet) toolbar, by using a macro, or by using Visual Basic.

You can also set this property by selecting the settings displayed under Gridlines Shown in the Cells Effects dialog box, available by clicking Cells on the Format menu.

You can set the default DatasheetGridlinesBehavior property by using the settings under Default Gridlines Showing on the Datasheet tab of the Options dialog box, available by clicking Options on the Tools menu.

Remarks

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

The following table contains the properties that do not exist in the Properties collection for TableDef or QueryDef objects until you add them using the CreateProperty method or set them using the Formatting (Datasheet) toolbar.

  • DatasheetBackColor
  • DatasheetCellsEffect
  • DatasheetFontHeight*

DatasheetFontItalic*

  • DatasheetFontName*
  • DatasheetFontUnderline*
  • DatasheetFontWeight*
  • DatasheetForeColor*
  • DatasheetGridlinesBehavior
  • DatasheetGridlinesColor

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.

See Also   BackColor property, DatasheetBackColor, DatasheetForeColor properties, DatasheetCellsEffect property, DatasheetFontItalic, DatasheetFontUnderline properties, DatasheetFontName, DatasheetFontHeight properties, DatasheetFontWeight property, DatasheetGridlinesColor property, FillColor property.