The following lists indicate miscellaneous intrinsic constants provided by Microsoft Access.
List Box and Combo Box Constants
You can use the following constants to fill a list box or combo box by using a function. You use these constants with a function that's the setting of the RowSourceType property, by using a special function format.
| acLBClose | acLBGetRowCount |
| acLBEnd | acLBGetValue |
| acLBGetColumnCount | acLBInitialize |
| acLBGetColumnWidth | acLBOpen |
| acLBGetFormat |
SysCmd Method Constants
You can use the following constants with the SysCmd method:
| acDataAccessPage | acSysCmdAccessVer |
| acDefault | acSysCmdClearHelpTopic |
| acDiagram | acSysCmdClearStatus |
| acForm | acSysCmdGetObjectState |
| acMacro | acSysCmdGetWorkgroupFile |
| acModule | acSysCmdIniFile |
| acObjStateDirty | acSysCmdInitMeter |
| acObjStateNew | acSysCmdProfile |
| acObjStateOpen | acSysCmdRemoveMeter |
| acQuery | acSysCmdRuntime |
| acReport | acSysCmdSetStatus |
| acServerView | acSysCmdUpdateMeter |
| acStoredProcedure | acTable |
| acSysCmdAccessDir |
ControlType Property, CreateControl and CreateReportControl Methods Constants
You can use one of the following constants with the ControlType property and the CreateControl and CreateReportControl methods to specify the control type:
| acBoundObjectFrame | acOptionButton |
| acCheckBox | acOptionGroup |
| acComboBox | acPage |
| acCommandButton | acPageBreak |
| acCustomControl | acRectangle |
| acImage | acSubform |
| acLabel | acTabCtl |
| acLine | acTextBox |
| acListBox | acToggleButton |
| acObjectFrame |
Section Property, CreateControl and CreateReportControl Methods Constants
You can use one of the following constants with the Section property and the CreateControl and CreateReportControl methodss to specify a section on a form or report:
| acDetail | acGroupLevel2Header |
| acFooter | acHeader |
| acGroupLevel1Footer | acPageFooter |
| acGroupLevel1Header | acPageHeader |
| acGroupLevel2Footer |
OLE Constants
The following table gives the OLE constants, and shows the language elements with which these constants can be used.
| OLE constants | Used with |
|---|---|
| acOLEActivate | Action property |
| acOLEActivateDoubleClick | AutoActivate property |
| acOLEActivateGetFocus | AutoActivate property |
| acOLEActivateManual | AutoActivate property |
| acOLEChanged | Updated event |
| acOLEClose | Action property |
| acOLEClosed | Updated event |
| acOLECopy | Action property |
| acOLECreateEmbed | Action property |
| acOLECreateFromFile (same as acOLECreateLink) | Action property |
| acOLECreateLink | Action property |
| acOLECreateNew (same as acOLECreateEmbed) | Action property |
| acOLEDelete | Action property |
| acOLEDisplayContent | DisplayType property |
| acOLEDisplayIcon | DisplayType property |
| acOLEEither | OLETypeAllowed property |
| acOLEEmbedded | OLEType property, OLETypeAllowed property |
| acOLEFetchVerbs | Action property |
| acOLEInsertObjDlg | Action property |
| acOLELinked | OLEType property, OLETypeAllowed property |
| acOLENone | OLEType property |
| acOLEPaste | Action property |
| acOLEPasteSpecialDlg | Action property |
| acOLERenamed | Updated event |
| acOLESaved | Updated event |
| acOLESizeAutoSize (not used) | SizeMode property |
| acOLESizeClip | SizeMode property |
| acOLESizeStretch | SizeMode property |
| acOLESizeZoom | SizeMode property |
| acOLEUpdate | Action property |
| acOLEUpdateAutomatic | UpdateOptions property |
| acOLEUpdateFrozen (not used) | UpdateOptions property |
| acOLEUpdateManual | UpdateOptions property |
| acOLEVerbHide | Verb property |
| acOLEVerbInPlaceActivate | Verb property |
| acOLEVerbInPlaceUIActivate | Verb property |
| acOLEVerbOpen | Verb property |
| acOLEVerbPrimary | Verb property |
| acOLEVerbShow | Verb property |
SpecialEffect Property Constants
The following list gives the constants you can use to specify or determine the state of the SpecialEffect property. The acEffectNormal, acEffectRaised, and acEffectSunken constants can also be used with the DatasheetCellsEffect property.
| acEffectChisel | acEffectRaised |
| acEffectEtched | acEffectShadow |
| acEffectNormal | acEffectSunken |
Gridlines Constants
The following list gives the constants you can use to specify or determine the state of the gridlines effect for an object in datasheet view. These constants can be used with the DatasheetGridlinesBehavior property.
| acGridlinesBoth | acGridlinesNone |
| acGridlinesBothV2 | acGridlinesVert |
| acGridlinesHoriz |
Type Constants
The following list gives the constants you can use to determine if the current module is a standard module or a class module. These constants can be used with the Type property.
| acClassModule | acStandardModule |
HyperlinkPart Function Constants
You can use the following constants with the HyperlinkPart function:
| acAddress | acFullAddress |
| acDisplayedValue | acScreenTip |
| acDisplayText | acSubAddress |
Procedure Constants
You can use the following constants with the ProcStartLine, ProcBodyLine, ProcOfLine, and ProcCountLines properties.
| vbext_pk_Get | vbext_pk_Proc |
| vbext_pk_Let | vbext_pk_Set |
Kind Property Constants
You can use the following constants with the Kind property of the Reference object:
| vbext_rk_Project | vbext_rk_TypeLib |
Conditional Formatting Constants
You can use the following constants with the Type property of the FormatCondition object:
| acExpression | acFieldValue |
| acFieldHasFocus |