Form.DatasheetBorderLineStyle property (Access)

Returns or sets a Byte indicating the line style to use for the border of the specified datasheet. Read/write.

Syntax

expression.DatasheetBorderLineStyle

expression A variable that represents a Form object.

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

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 for you to see the change.

Forms(0).DatasheetBorderLineStyle = 3 

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.