DatasheetBackColor, DatasheetForeColor Properties

See Also         Example         Applies To

• You can use the DatasheetBackColor property in Visual Basic to specify or determine the background color of an entire table, query, or form in Datasheet view within a Microsoft Access database (.mdb).
  
  
• 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 (.mdb).

Setting

The DatasheetBackColor and DatasheetForeColor properties are a Long Integer value representing the background color and font color setting for a datasheet.

The following setting information applies to both Microsoft Access database and Access projects (.adp):

• You can also set these properties by clicking Fill/BackColor or Font/ForeColor on the Formatting (Datasheet) toolbar and clicking the desired color displayed on the color palette.
  
  
• You can also set the default DatasheetBackColor and DatasheetForeColor properties by using the Datasheet tab of the Options dialog box, available by clicking Options on the Tools menu.

Remarks

Setting the DatasheetBackColor or DatasheetForeColor properties for a table or query won't affect these property settings 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 (.mdb) by using the CreateProperty method and append it to the DAO Properties collection.

Note   When you add or set any property listed with an asterisk, Microsoft Access automatically adds it to the Properties collection.