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.

See also

Support and feedback

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.