DatasheetBorderLineStyle Property [Access 2003 VBA Language Reference]
Returns or sets a Byte indicating the line style to use for the border of the specified datasheet. Read/write.
expression.DatasheetBorderLineStyle
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
Valid values are between zero and eight. Values greater than eight 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 |
| 8 | Double solid |
This property is not supported when saving a form as a data access page.
Example
This example sets the datasheet border line style on the first open form to short dashes. The form must be set to Datasheet View in order for you to see the change.
Forms(0).DatasheetBorderLineStyle = 3
Applies to | Form Object
See Also | DatasheetCellsEffect Property | DatasheetColumnHeaderUnderlineStyle Property | DatasheetGridlinesBehavior Property | DatasheetGridlinesColor Property | HorizontalDatasheetGridlineStyle Property | VerticalDatasheetGridlineStyle Property