DatasheetFontWeight Property

See Also         Example         Applies To

You can use the DatasheetFontWeight property to specify the line width of the font used to display and print characters for field names and data in Datasheet view.

Notes   The DatasheetFontWeight property applies to all fields in Datasheet view and to form controls when the form is in Datasheet view.

These properties are only available in Visual Basic within a Microsoft Access database (.mdb)

Setting

In Visual Basic, the DatasheetFontWeight property setting uses the following Integer values.

The following setting information applies to both Access databases (.mdb) and Access projects (.adp):

• You can also set Normal and Bold for this property in the Font dialog box, available by clicking Font on the Format menu in Datasheet view. In the Font dialog box's Font Style box, the only available font weight settings are Regular (identical to Normal) and Bold.
  
  
• Another method of setting only the Regular and Bold settings is to click Bold on the Formatting (Datasheet) toolbar.
  
  
• You can set the default DatasheetFontWeight property by using the settings under Default Font on the Datasheet tab of the Options dialog box, available by clicking Options on the Tools menu.

Remarks

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 all the properties listed with an asterisk to the Properties collection of the database.