Enumerations (Access)
This section contains documentation for the enumerations in the Access object model.
Enumeration | Description |
---|---|
AcAggregateType | Specifies the type of aggregation to apply to a set of values. |
AcAxisRange | Specifies the behavior for representing minimum and maximum values on an axis. |
AcAxisUnits | Specifies the unit of measurement for values displayed on an axis. |
AcBrowseToObjectType | Specifies the type of object to browse to. |
AcChartType | Specifies the chart type. |
AcCloseSave | Used by the Close method to specify whether or not to save an object upon closing. |
AcColorIndex | Specifies the color to apply. |
AcCommand | Used with the RunCommand method to run built-in commands. |
AcControlType | Specifies the type of control created by the CreateControl and CreateReportControl methods. |
AcCurrentView | Used with the CurrentView property to determine the current view of an object. |
AcCursorOnHover | Used with the CursorOnHover property to specify the type of cursor displayed when a user rests the pointer on a button. |
AcDashType | Specifies the line dash style for a series when its effective chart type is line-based. |
AcDataObjectType | Used with the GoToRecord method to specify the type of object that contains the record to make current. |
AcDataTransferType | Specifies the type of transfer that you want to make with the TransferDatabase or TransferSpreadsheet method. |
AcDateGroupType | Specifies the type of grouping applied to an axis; the type of its associated field is a date. |
AcDefReportView | Use with the DefaultView property to set or return the opening view of a report. |
AcDefView | Use with the DefaultView property to set or return the opening view of a form. |
AcDisplayAs | Use with the DisplayAs property to specify what is displayed in an Attachment control. |
AcDisplayAsHyperlink | Used with the DisplayAsHyperlink property to specify whether to display the contents of a text box or combo box as a hyperlink. |
AcExportQuality | Use with the OutputTo method to specify the type of output device to optimize for when exporting an object. |
AcExportXMLEncoding | Use with the ExportXML method to specify the text encoding to use for exporting XML data. |
AcExportXMLObjectType | Use with the ExportXML method to specify the type of object to export. |
AcExportXMLOtherFlags | Use with the ExportXML method to specify other behaviors associated with exporting to XML. |
AcExportXMLSchemaFormat | Not supported in Access. |
AcFileFormat | Specifies the Microsoft Access file format to use when converting an Access file. |
AcFilterType | Not supported in Access. |
AcFindField | Specifies whether the search is confined to the current field in each record or includes all fields in each record. |
AcFindMatch | Specifies where the data is located in the field. |
AcFormatBarLimits | Specifies how the threshold values for a Data Bar is determined. |
AcFormatConditionOperator | Specifies the operator to apply when using the Add method to create a conditional format. |
AcFormatConditionType | Specifies the type of conditional formatting to apply to a control. |
AcFormOpenDataMode | Specifies the data entry mode of a form. |
AcFormView | Specifies the view when opeing a form. |
AcHorizontalAnchor | Used with the HorizontalAnchor property to specify how a control is anchored horizontally within its layout. |
AcHyperlinkPart | Specifies the information you want returned by the HyperlinkPart method. |
AcImeMode | Specifies the default startup mode for the Japanese Input Method Editor (IME). |
AcImeSentenceMode | Used with the IMESentenceMode property to specify the IME sentence mode for the IMM. |
AcImportXMLOption | Specifies the action to take when using the Application.ImportXML method (Access) method to import data from an XML file. |
AcLayoutType | Specifies the type of layout that the control is part of. |
AcLegendPosition | Specifies the position of a legend relative to its associated chart. |
AcMarkerType | Specifies the marker shape to use for plotting a series when its effective chart type is line-based. |
AcMissingDataPolicy | Specifies the plotting strategy of a series when its chart type is acChartLine and values are missing. |
AcModuleType | Returns the type of the specified Visual Basic module. |
AcNavigationSpan | Specifies the orientation of navigation buttons. |
AcNewDatabaseFormat | Used with the NewCurrentDatabase method to specify the database format of the newly created database. |
AcObjectType | Specifies the type of object. |
AcOpenDataMode | Specifies the data entry mode when opening a table, query, stored procedure, view, or user-defined function. |
AcOutputObjectType | Specifies the type of object to output when using the OutputTo method. |
AcPictureCaptionArrangement | Used with the PictureCaptionArrangement property to determine how a button's caption is arranged in relation to its picture. |
AcPrintColor | Used with the ColorMode property to specify whether the printer should print output in color or monochrome. |
AcPrintDuplex | Used with the Duplex property to specify how the printer handles duplex printing. |
AcPrintItemLayout | Used with the ItemLayout property to specify how columns are laid out when printing. |
AcPrintObjQuality | Used with the PrintQuality property to specify the resolution at which the specified printer should print jobs. |
AcPrintOrientation | Used with the Orientation property to specify a printer's print orientation. |
AcPrintPaperBin | Used with the PaperBin property to indicate which paper bin the specified printer should use. |
AcPrintPaperSize | Used with the PaperSize property to indicate the paper size to use when printing. |
AcPrintQuality | Used with the PrintOut method to specify the print quality of a particular print job. |
AcPrintRange | Used with the PrintOut method to specify the range to print. |
AcProjectType | Used with the ProjectType property to determine the type of project that is currently open. |
AcProperty | Used with the SetProperty method to specify which property to set for a control. |
AcQuitOption | Used with the Quit method to specify whether or not to save changes to the database when quitting Microsoft Access. |
AcRecord | Used with the GoToRecord method to specify which record to make the current record. |
AcResourceType | Specifies the type of a SharedResource object. |
AcSearchDirection | Used with the DoCmd.FindRecord method (Access) method to specify the direction to search. |
AcSection | Specifies the section that will contain the new control. |
AcSendObjectType | Used with the DoCmd.SendObject method (Access) method to specify the type of object to send. |
AcSeparatorCharacters | Used with the ComboBox.SeparatorCharacters property (Access) property to specify the separator displayed between values in combo boxes that are linked to multi-valued fields. |
AcSharePointListTransferType | Used with the DoCmd.TransferSharePointList method (Access) method to specify whether to import or link to a SharePoint list. |
AcShowToolbar | Used with the DoCmd.ShowToolbar method (Access) method to specify whether to display a particular custom toolbar. |
AcSplitFormDatasheet | Used with the Form.SplitFormDatasheet property (Access) property to specify whether the user can edit contents of the datasheet while a form is displayed in Split Form view. |
AcSplitFormOrientation | Used with the SplitFormOrientation property to specify the orientation of the datasheet in relation to the form while in Split Form view. |
AcSplitFormPrinting | Used with the SplitFormPrinting property to specify what to print when a form is in Split Form view. |
AcSpreadSheetType | Used with the TransferSpreadsheet method to specify the type of spreadsheet to import from, export to, or link to. |
AcSysCmdAction | Used with the SysCmd method to specify an action to take. |
AcTextFormat | Used with the TextFormat property to specify whether or not rich text is displayed in a Text Box. |
AcTextTransferType | Used with the DoCmd.TransferText method (Access) method to specify the type of transfer you want to make. |
AcTransformXMLScriptOption | Used with the TransformXML method to specify the action taken if the XSL file contains scripting code. |
AcTrendlineOptions | Specifies the type of trendline to render for a chart series. |
AcValueAxis | A list of value axes in a chart. |
AcVerticalAnchor | Used with the VerticalAnchor property to specify how a control is anchored vertically within its layout. |
AcView | Specifies an object's view. |
AcWebBrowserScrollBars | Used by the ScrollBars property to specify whether scroll bars are displayed. |
AcWebBrowserState | Used by the ReadyState property to determine the state of the web browser control. |
AcWebUserDisplay | Specifies information about the current user of a Web database. |
AcWebUserGroupsDisplay | Specifies the type of information to return about the group membership of the current user of a Web database. |
AcWindowMode | Specifies the mode in which a form or report is opened. |
- OldConstants (Legacy constants)
- Intrinsic constants as bit masks
- Microsoft Access constants overview
- Constants enumeration (Access)
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.