DatasheetFontItalic, DatasheetFontUnderline Properties

DatasheetFontItalic, DatasheetFontUnderline Properties

See Also         Example         Applies To

You can use the DatasheetFontItalic and DatasheetFontUnderline properties to specify an italic or underlined appearance for field names and data in Datasheet view.

Notes   The DatasheetFontItalic and DatasheetFontUnderline properties apply 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 DatasheetFontItalic property uses the following settings.

Setting Description
True (–1) The text is italic.
False (0) (Default) The text isn't italic.

In Visual Basic, the DatasheetFontUnderline property uses the following settings.

Setting Description
True The text is underlined.
False (Default) The text isn't underlined.

In Visual Basic, these property settings are Boolean values.

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

You can set these properties by clicking Italic or Underline on the Formatting (Datasheet) toolbar.

You can also set these properties in the Font dialog box, available by clicking Font on the Format menu in Datasheet view.

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.

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.