Type Property [Access 2003 VBA Language Reference]

Type property as it applies to the AccessObject object.

AccessObject

AcObjectType can be one of these AcObjectType constants.

acDataAccessPage

acDefault

acDiagram

acForm

acFunction

acMacro

acModule

acQuery

acReport

acServerView

acStoredProcedure

acTable

expression.Type

expression Required. An expression that returns an AccessObject object.

Type property as it applies to the FormatCondition object.

FormatCondition

AcFormatConditionType can be one of these AcFormatConditionType constants.

acExpression

acFieldHasFocus

acFieldValue

expression.Type

expression Required. An expression that returns a FormatCondition object.

Type property as it applies to the Module object.

AcModuleType

AcModuleType can be one of these AcModuleType constants.

acClassModule

acStandardModule

expression.Type

expression Required. An expression that returns a Module object.

Example

As it applies to the Module object.

The following example determines whether a Module object represents a standard module or a class module:

Function CheckModuleType(strModuleName As String) As Integer
    Dim mdl As Module

    ' Open module to include in Modules collection.
    DoCmd.OpenModule strModuleName
    ' Return reference to Module object.
    Set mdl = Modules(strModuleName)
    ' Check Type property.
    If mdl.Type = acClassModule Then
        ' Insert comment.
        mdl.InsertLines 1, "' Class module."
        CheckModuleType = acClassModule
    Else
        ' Insert comment.
        mdl.InsertLines 1, "' Standard module."
        CheckModuleType = acStandardModule
    End If
End Function

Applies to | AccessObject Object | FormatCondition Object | Module Object