I am using:
Forms(strFormName).Controls(strFieldLabelName).Properties("Caption").Value = Me.New_Field_Label_Caption
To change the caption of some labels. The code works fine so if I run it then open the form, the label has the proper new caption, however if I close and reopen the database, it revents to its original caption.
Will I just have to use an 'On Load' event for the form every time it's opened, or is there a way to make the change stick?
Forms(strFormName).Controls(strFieldLabelName).Properties("Caption").Value = Me.New_Field_Label_Caption
To change the caption of some labels. The code works fine so if I run it then open the form, the label has the proper new caption, however if I close and reopen the database, it revents to its original caption.
Will I just have to use an 'On Load' event for the form every time it's opened, or is there a way to make the change stick?