Form.HorizontalDatasheetGridlineStyle property (Access)
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 for you to see the change.
Forms(0).HorizontalDatasheetGridlineStyle = 6
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.