This documentation is archived and is not being maintained.

Modules Property [Access 2003 VBA Language Reference]

Office 2003

You can use the Modules property to access the Modules collection and its related properties. Read-only Modules object.


expression Required. An expression that returns one of the objects in the Applies To list.


This property is available only by using Visual Basic .

Use the properties of the Modules collection in Visual Basic to refer to all open standard modules and class modules.


The following example uses the Module property to insert the Beep method in a form's Open event.

Dim strFormOpenCode As String
Dim mdl As Module

Set mdl = Forms!MyForm.Module
strFormOpenCode = "Sub Form_Open(Cancel As Integer)" _
    & vbCrLf & "Beep" & vbCrLf & "End Sub"
    With mdl
        .InsertText strFormOpenCode
    End With

Applies to | Application Object

See Also | Module Object