NeoPa
Thanks. Cool. That is good to know. It might not be the best approach, but I used the Forms object. I also had to update all the Title text, combo boxes etc. to improve the look of the User Interface. So I wrote something that checked to see if there were labels, combos, commands, etc., then applied a standard design. I made it our standard format tool. Guess I will have to try and refine it using the allforms command.
The good news, it all worked till I had to create a control and load a picture. I have not gotten that working yet. Any suggestions for that let me know. I just want to insert an banner image at the top of the form. I was trying to use LoadPicture, but the program stops in the middle with no error message.
Thanks again.
Vikki
Example:
- Forms(myForm).Detail.BackColor = RGB(192, 192, 192)
-
For i = 1 To 100
-
If funControlExists(Forms(myForm), myLabel) = True Then
-
Forms(myForm).Controls(myLabel).FontName = "Tahoma"
-
Forms(myForm).Controls(myLabel).FontSize = 10
-
Forms(myForm).Controls(myLabel).FontBold = 1
-
Forms(myForm).Controls(myLabel).ForeColor = 0
-
End If
-
myLabel = "Label" & i
-
Next i