(Q) How can I convert all text in a control to all Upper/Lower case automatically?
(A) You can either use Input Masks for the control to make sure the users only type in
all proper case or you can convert whatever was typed to the required case using the Lcase
or Ucase functions. For example:
Me!someControl = Ucase(me!SomeControl)
This code snippet will automatically convert all strings in the control SomeControl in
the current form to the required case.