Form, Query, Table.
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.
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 using the Formatting toolbar (in Datasheet view), a macro, or Visual Basic.
You can also set this property by choosing Cells from the Format menu.
You can set the default DatasheetCellsEffect property using the Datasheet tab of the Options dialog on the Tools menu.
The DatasheetCellsEffect property applies the selected effect to the entire datasheet.
When the DatasheetCellsEffect property is set to Raised or Sunken, grid lines will be visible on the datasheet regardless of the DatasheetGridLinesBehavior property setting.
DatasheetGridLinesBehavior Property, DatasheetGridLinesColor Property.