Type Property

Microsoft Access Visual Basic

Show All

Type Property

       

Type property as it applies to the AccessObject object.

Returns the value of an AccessObject object type. Read-only AcObjectType.

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.

Returns the value of a FormatCondition object type. Read-only AcFormatConditionType.

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.

Indicates whether a module is a standard module or a class module. Read-only 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