HorizontalDatasheetGridlineStyle Property
Returns or sets a Byte indicating the line style to use for horizontal gridlines on the specified datasheet. Read/write.
expression.HorizontalDatasheetGridlineStyle
expression Required. An expression that returns one of the objects in the Applies To list.
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 |
This property is not supported when saving a form as a data access page.
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.
Forms(0).HorizontalDatasheetGridlineStyle = 6