Table of contents
TOC
Collapse the table of content
Expand the table of content

EmptyCell.SpecialEffect Property (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

You can use the SpecialEffect property to specify whether special formatting will apply to the specified object. Read/write Byte.

Syntax

expression. SpecialEffect

expression A variable that represents an EmptyCell object.

Remarks

The SpecialEffect property uses the following settings.

SettingVisual BasicDescription
Flat0The object appears flat and has the system's default colors or custom colors that were set in Design view.
Raised1The object has a highlight on the top and left and a shadow on the bottom and right.
Sunken2The object has a shadow on the top and left and a highlight on the bottom and right.
Etched3The object has a sunken line surrounding the control.
Shadowed4The object has a shadow below and to the right of the control.
Chiseled5The object has a sunken line below the control.

The SpecialEffect property setting affects related property settings for the BorderStyle, BorderColor, and BorderWidth properties. For example, if the SpecialEffect property is set to Raised, the settings for the BorderStyle, BorderColor, and BorderWidth properties are ignored. In addition, changing or setting the BorderStyle, BorderColor, and BorderWidth properties may cause Microsoft Access to change the SpecialEffect property setting to Flat.

Note When you set the SpecialEffect property of a text box to Shadowed, the vertical height of the text display area is reduced. You can adjust the Height property of the text box to increase the size of the text display area.

Example

The following example sets the appearance of the text box "OrganizationName1" on the "Mailing List" form to raised.

Forms("Mailing List").Controls("OrganizationName1").SpecialEffect = 1

See also

Concepts

EmptyCell Object

© 2018 Microsoft