This documentation is archived and is not being maintained.

Form.DatasheetBorderLineStyle Property

Office 2007
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.

ValueDescription
0Transparent border
1Solid
2Dashes
3Short dashes
4Dots
5Sparse dots
6Dash-dot
7Dash-dot-dot
8Double 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 in order for you to see the change.

Visual Basic for Applications
Forms(0).DatasheetBorderLineStyle = 3



Show: