Form.HorizontalDatasheetGridlineStyle Property

Access Developer Reference

Returns or sets a Byte indicating the line style to use for horizontal gridlines on the specified datasheet. Read/write.

Syntax

expression.HorizontalDatasheetGridlineStyle

expression   A variable that represents a Form object.

Remarks

Valid values are between zero and seven. Values greater than seven are ignored; negative values or values above 255 cause an error.

Value Description
0 Transparent border
1 Solid
2 Dashes
3 Short dashes
4 Dots
5 Sparse dots
6 Dash-dot
7 Dash-dot-dot

Example

This example sets the horizontal gridline style on the first open form to dash-dot. The form must be set to Datasheet View in order for you to see the change.

Visual Basic for Applications
  Forms(0).HorizontalDatasheetGridlineStyle = 6

See Also