DatasheetFontWeight Property

Applies To   Form object, QueryDef object, TableDef object.

Description

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.

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

Setting

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

Setting

Description

100

Thin

200

Extra Light

300

Light

400

(Default) Normal

500

Medium

600

Semi-bold

700

Bold

800

Extra Bold

900

Heavy


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 the Bold button 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.

The following table contains the properties that do not exist in the Properties collection for TableDef or QueryDef objects until you add them using the CreateProperty method or set them using the Formatting (Datasheet) toolbar.

  • DatasheetBackColor
  • DatasheetCellsEffect
  • DatasheetFontHeight*

DatasheetFontItalic*

  • DatasheetFontName*
  • DatasheetFontUnderline*
  • DatasheetFontWeight*
  • DatasheetForeColor*
  • DatasheetGridlinesBehavior
  • DatasheetGridlinesColor

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.

See Also   BackColor property, DatasheetBackColor, DatasheetForeColor properties, DatasheetCellsEffect property, DatasheetFontItalic, DatasheetFontUnderline properties, DatasheetFontName, DatasheetFontHeight properties, DatasheetGridlinesBehavior property, DatasheetGridlinesColor property, FillColor property.

Example

See the DatasheetFontName, DatasheetFontHeight properties example.