3 4
Following is a list of control properties and the controls they apply to. A few properties are only available in VBA code; they are indicated by the text "(VBA only)" after the property or control names. For more information about a control property (including some of the more obscure properties not described in this book), position the insertion point in the property box of the properties sheet and press F1 to open context-specific Help.
Access control properties
Property | Applies to |
Action | VBA only |
AllowAutoCorrect | Combo Box |
Text Box | |
AutoActivate | Bound Object Frame |
Unbound Object Frame | |
AutoExpand | Combo Box |
AutoRepeat | Command Button |
AutoTab | Text Box |
BackColor | Bound Object Frame |
Combo Box | |
Image | |
Label | |
List Box | |
Option Group | |
Rectangle | |
Text Box | |
Unbound Object Frame | |
BackStyle | Bound Object Frame |
Combo Box | |
Image | |
Label | |
Option Group | |
Rectangle | |
Tab Control | |
Text Box | |
Unbound Object Frame | |
BorderColor | Bound Object Frame |
Check Box | |
Combo Box | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Rectangle | |
Subform | |
Text Box | |
Unbound Object Frame | |
BorderLineStyle | VBA only |
BorderStyle | Bound Object Frame |
Check Box | |
Combo Box | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Rectangle | |
Subform | |
Text Box | |
Unbound Object Frame | |
BorderWidth | Bound Object Frame |
Check Box | |
Combo Box | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Subform | |
Rectangle | |
Text Box | |
Unbound Object Frame | |
BottomMargin | Label |
Text Box | |
BoundColumn | Combo Box |
List Box | |
Cancel | Command Button |
CanGrow | Text Box |
Subform | |
CanShrink | Text Box |
Subform | |
Caption | Command Button |
Label | |
Toggle Button | |
Class | VBA only |
ColumnCount | Combo Box |
List Box | |
Unbound Object Frame | |
ColumnHeads | Combo Box |
List Box | |
Unbound Object Frame (VBA only) | |
ColumnHidden | VBA only |
ColumnOrder | VBA only |
ColumnWidth | VBA only |
ColumnWidths | Combo Box |
List Box | |
ConditionalFormat | Combo Box |
Text Box | |
ControlSource | Bound Object Frame |
Check Box | |
Combo Box | |
List Box | |
Option Group | |
Text Box | |
Toggle Button | |
ControlTipText | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
List Box | |
Option Button | |
Option Group | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
ControlType | VBA only |
DecimalPlaces | Combo Box |
Text Box | |
Default | VBA only |
DefaultValue | Check Box |
Combo Box | |
List Box | |
Option Group | |
Text Box | |
Toggle Button | |
DisplayType | Bound Object Frame |
Unbound Object Frame | |
DisplayWhen | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Rectangle | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
Enabled | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
List Box | |
Option Button | |
Option Group | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
EnterKeyBehavior | Text Box |
EventProcPrefix | VBA only |
FilterLookup | Text Box |
FontBold | VBA only (set through Font Weight property in the interface) |
FontItalic | Combo Box |
Command Button | |
Label | |
List Box | |
Tab Control | |
Text Box | |
Toggle Button | |
FontName | Combo Box |
Command Button | |
Label | |
List Box | |
Tab Control | |
Text Box | |
Toggle Button | |
FontSize | Combo Box |
Command Button | |
Label | |
List Box | |
Tab Control | |
Text Box | |
Toggle Button | |
FontUnderline | Combo Box |
Command Button | |
Label | |
List Box | |
Tab Control | |
Text Box | |
Toggle Button | |
FontWeight | Combo Box |
Command Button | |
Label | |
List Box | |
Tab Control | |
Text Box | |
Toggle Button | |
ForeColor | Combo Box |
Command Button | |
Label | |
List Box | |
Text Box | |
Toggle Button | |
Format | Combo Box |
Text Box | |
Height | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Rectangle | |
Tab Control | |
Subform | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
HelpContextId | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
List Box | |
Option Button | |
Option Group | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
HyperlinkAddress | Command Button |
Image | |
HyperlinkSubAddress | Command Button |
Image | |
ImageHeight | Image |
ImageWidth | Image |
IMEHold | Combo Box |
List Box | |
Text Box | |
IMEMode | Combo Box |
List Box | |
Text Box | |
IMESentenceMode | Combo Box |
List Box | |
Text Box | |
InputMask | Combo Box |
Text Box | |
InSelection | VBA only |
IsHyperlink | Combo Box |
Text Box | |
Item | VBA only |
KeyboardLanguage | Combo Box |
Text Box | |
Left | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Page Break | |
Subform | |
Rectangle | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
LeftMargin | Label |
Text Box | |
LimitToList | Combo Box |
LineSlant | Line |
LineSpacing | Label |
Text Box | |
LinkChildFields | Subform |
Unbound Object Frame | |
LinkMasterFields | Subform |
Unbound Object Frame | |
ListCount | VBA only |
ListIndex | VBA only |
ListRows | Combo Box |
ListWidth | Combo Box |
Locked | Bound Object Frame |
Check Box | |
Combo Box | |
List Box | |
Option Button | |
Option Group | |
Subform | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
LpOleObject | VBA only |
MultiRow | Tab Control |
MultiSelect | List Box |
Name | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Page Break | |
Rectangle | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
NumeralShapes | Combo Box |
Label | |
List Box | |
Text Box | |
ObjectPalette | VBA only |
ObjectVerbsCount | VBA only |
OldBorderStyle | VBA only |
OLEClass | Unbound Object Frame |
OLEType | Bound Object Frame |
Unbound Object Frame | |
OLETypeAllowed | Bound Object Frame |
Unbound Object Frame | |
OptionValue | Option Button |
Picture | Command Button |
Image | |
Toggle Button | |
PictureAlignment | Image |
PictureData | VBA only |
PictureTiling | Image |
PictureType | Command Button |
Image | |
Toggle Button | |
ReadingOrder | Check Box |
Combo Box | |
Command Button | |
Label | |
List Box | |
Option Button | |
Text Box | |
Toggle Button | |
RightMargin | Label |
Text Box | |
RowSource | Combo Box |
List Box | |
Unbound Object Frame | |
RowSourceType | Combo Box |
List Box | |
Unbound Object Frame | |
ScrollBarAlign | Combo Box |
List Box | |
Text Box | |
ScrollBars | Text Box |
Section | VBA only |
SelLength | Combo Box |
Text Box | |
SelStart | Combo Box |
Text Box | |
SelText | Combo Box |
Text Box | |
ShortcutMenuBar | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
List Box | |
Option Button | |
Option Group | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
SizeMode | Bound Object Frame |
Image | |
Unbound Object Frame | |
SourceDoc | Bound Object Frame |
Unbound Object Frame | |
SourceItem | Bound Object Frame |
| Unbound Object Frame |
SourceObject | Subform |
Unbound Object Frame (VBA only) | |
SpecialEffect | Bound Object Frame |
Check Box | |
Combo Box | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Rectangle | |
Subform | |
Text Box | |
Unbound Object Frame | |
StatusBarText | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
List Box | |
Option Button | |
Option Group | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
Style | Tab Control |
TabFixedHeight | Tab Control |
TabFixedWidth | Tab Control |
TabIndex | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
List Box | |
Option Group | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
TabStop | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
List Box | |
Option Group | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
Tag | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Page Break | |
Rectangle | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
Text | VBA only |
TextAlign | Combo Box |
Label | |
Text Box | |
TextFontCharSet | VBA only |
Top | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Page Break | |
Rectangle | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
TopMargin | Label |
Text Box | |
Transparent | Command Button |
TripleState | Check Box |
Toggle Button | |
UpdateOptions | Bound Object Frame |
Unbound Object Frame | |
ValidationRule | Check Box |
Combo Box | |
List Box | |
Option Group | |
Text Box | |
Toggle Button | |
ValidationText | Check Box |
Combo Box | |
List Box | |
Option Group | |
Text Box | |
Toggle Button | |
Verb | Bound Object Frame |
Unbound Object Frame | |
Vertical | Label |
Text Box | |
Visible | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Page Break | |
Rectangle | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame | |
Width | Bound Object Frame |
Check Box | |
Combo Box | |
Command Button | |
Image | |
Label | |
Line | |
List Box | |
Option Button | |
Option Group | |
Rectangle | |
Subform | |
Tab Control | |
Text Box | |
Toggle Button | |
Unbound Object Frame |