good day all,
im hoping someone knows how to manipulate the properties on forms thru VBA code??
the thing i want to do is change a few properties on ALL the forms in my DB - theres about 20 or so. i've bin able to figure out the code using collections to list all the names of the forms.
If dbContainer.name = "Forms" Then
For Each conDocument In dbContainer.Documents
Debug.Print conDocument.name
Set frm = conDocument.name
With frm
Debug.Print .Caption
End With
Next conDocument
End If
the debug.print gives me the list so i thought if i set a form variable with the name i could get to the properties. however i get an error about a type mismatch when i try to set the variable.
so is there a way to do this?? or do i have to go thru each form individually to change them??
- Topher
im hoping someone knows how to manipulate the properties on forms thru VBA code??
the thing i want to do is change a few properties on ALL the forms in my DB - theres about 20 or so. i've bin able to figure out the code using collections to list all the names of the forms.
If dbContainer.name = "Forms" Then
For Each conDocument In dbContainer.Documents
Debug.Print conDocument.name
Set frm = conDocument.name
With frm
Debug.Print .Caption
End With
Next conDocument
End If
the debug.print gives me the list so i thought if i set a form variable with the name i could get to the properties. however i get an error about a type mismatch when i try to set the variable.
so is there a way to do this?? or do i have to go thru each form individually to change them??
- Topher
