DatasheetFontName Property

Microsoft Access Visual Basic

Show All Show All

DatasheetFontName Property

You can use the DatasheetFontName property to specify the font used to display and print field names and data in Datasheet view.

Remarks

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

This property is only available in Visual Basic within a Microsoft Access database (.mdb).

You can set this property by selecting the font name from the Font box on the Formatting (Datasheet) toolbar.

You can also set this property with the Font box in the Font dialog box, available by clicking Font on the Format menu in Datasheet view.

For the DatasheetFontName property, the font names you can specify depend on the fonts installed on your system and for your printer. If you specify a font that your system can't display or that isn't installed, Microsoft Windows will substitute a similar font.

You can set the default DatasheetFontName 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.

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.

DatasheetFontItalic * DatasheetForeColor *
DatasheetFontHeight * DatasheetBackColor
DatasheetFontName * DatasheetGridlinesColor
DatasheetFontUnderline * DatasheetGridlinesBehavior
DatasheetFontWeight * DatasheetCellsEffect

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.