DatasheetCellsEffect Property

Applies To   Form object, QueryDef object, TableDef object.

Description

You can use the DatasheetCellsEffect property to specify whether special effects are applied to cells in a datasheet.

Note The DatasheetCellsEffect property applies only to objects in Datasheet view.

Setting

The DatasheetCellsEffect property uses the following settings.

Setting

Description

Visual Basic

Value

Flat

(Default) No special effects are applied to the cells in the datasheet.

acEffectNormal

0

Raised

Cells in the datasheet appear raised.

acEffectRaised

1

Sunken

Cells in the datasheet appear sunken.

acEffectSunken

2


You can set this property by using Special Effect button on the Formatting (Datasheet) toolbar, by using a macro, or by using Visual Basic.

You can also set this property by selecting the type of cell effect under Cell Effect in the Cells Effects dialog box, available by clicking Cells on the Format menu.

You can set the default DatasheetCellsEffect property by using the settings under Default Cell Effect on the Datasheet tab of the Options dialog box, available by clicking Options on the Tools menu.

Remarks

This property applies the selected effect to the entire datasheet.

When this property is set to Raised or Sunken, gridlines will be visible on the datasheet regardless of the DatasheetGridlinesBehavior property setting.

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, DatasheetFontItalic, DatasheetFontUnderline properties, DatasheetFontName, DatasheetFontHeight properties, DatasheetFontWeight property, DatasheetGridlinesBehavior property, DatasheetGridlinesColor property, ForeColor property.