Edit

Form.DatasheetCellsEffect property (Access)

  • Article

Use the DatasheetCellsEffect property to specify whether special effects are applied to cells in a datasheet. Read/write Byte.

Syntax

expression.DatasheetCellsEffect

expression A variable that represents a Form object.

Remarks

The DatasheetCellsEffect property applies only to objects in Datasheet view.

This property is only available within a Microsoft Access database.

The DatasheetCellsEffect property uses the following settings.

Setting Visual Basic Description
Flat acEffectNormal (Default) No special effects are applied to the cells in the datasheet.
Raised acEffectRaised Cells in the datasheet appear raised.
Sunken acEffectSunken Cells in the datasheet appear sunken.

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 don't exist in the DAO Properties collection 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.

Properties Properties Continued
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 in the database.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.