Strings: Convert all text to Upper/Lower case

(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:

'******************* Code Start ****************
Sub someControl_AfterUpdate()
    Me!someControl = Ucase(me!SomeControl)
        ' OR
        ' me!SomeControl = Lcase(me!SomeControl)
End Sub
'******************* Code End ****************

This code snippet will automatically convert all strings in the control SomeControl in the current form to the required case.