Applies To
Form object, QueryDef object, TableDef object.
Description
You can use the DatasheetGridlinesColor property to specify the color of gridlines in a datasheet.
Note The DatasheetGridlinesColor property applies only to objects in Datasheet view.
Setting
The DatasheetGridlinesColor property setting is a Long Integer value. In Visual Basic, you can also use the RGB or QBColor functions to set this property.
You can set this property by using the LineColor button on the Formatting (Datasheet)toolbar, by using a macro, or by using Visual Basic.
You can also set this property by clicking Cells on the Format menu and displaying the CellsEffects dialog box. You can then select an available color from the drop-down list under GridlineColor.
You can set the default DatasheetGridlinesColor property by using the settings under Default Colors on the Datasheet tab of the Options dialog box, available by clicking Options on the Tools menu.
Remarks
This property setting affects the gridline color for the entire datasheet. It's not possible to set the gridline color of individual cells in Datasheet view.
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, DatasheetGridlinesBehavior property, FillColor property.