GrunleStan
Registered User.
- Local time
- Tomorrow, 03:57
- Joined
- Aug 7, 2018
- Messages
- 22
I find having to have my Property windows open and double checking tons of forms to edit a caption very tedious.
And so I was able to set the captions of a form via VBA code! Hooray !
But when I tried to do it for a Header label, the code seems to fall flat on its face :banghead:.
I have the following in the form header;
Private Sub Form_Open(Cancel As Integer)
Me.Auto_Header0 = "Staff Data View - SDC Division (Edits Disabled)"
Me.Caption = "Staff Data View - SDCD"
End Sub
The 1st line results in "Run Time Error 438 : The object doesn't support this property or method"
Am I assigning the text too early ? it is just a Label, and I have been able to do so other times.
And so I was able to set the captions of a form via VBA code! Hooray !
But when I tried to do it for a Header label, the code seems to fall flat on its face :banghead:.
I have the following in the form header;
Private Sub Form_Open(Cancel As Integer)
Me.Auto_Header0 = "Staff Data View - SDC Division (Edits Disabled)"
Me.Caption = "Staff Data View - SDCD"
End Sub
The 1st line results in "Run Time Error 438 : The object doesn't support this property or method"
Am I assigning the text too early ? it is just a Label, and I have been able to do so other times.