Form.DatasheetForeColor Property
Access Developer Reference |
You can use the DatasheetForeColor property in Visual Basic to specify or determine the color of all text in a table, query, or form in Datasheet view within an Access database. Read/write Long.
Syntax
expression.DatasheetForeColor
expression A variable that represents a Form object.
Remarks
Setting the DatasheetForeColor property for a table or query won't affect this property setting for a form that uses the table or query as its source of data.
The following table contains the properties that don't exist in the DAO Properties collection of until you set them by using the Formatting (Datasheet) toolbar or you can add them in an Access database by using the CreateProperty method and append it to the DAO Properties collection.
* | |
* | |
* | DatasheetForeColor * |
* | |
* |
Note |
---|
When you add or set any property listed with an asterisk, Microsoft Access automatically adds it to the Properties collection. |
Example
The following example uses the SetTableProperty procedure to set a table's font color to dark blue and its background color to light gray. If a "Property not found" error occurs when the property is set, the CreateProperty method is used to add the property to the object's Properties collection.
Visual Basic for Applications |
---|
|
See Also