auto capitalise text fields

[djmatrix]

On my form i have several fields that i want to auto capitalize. Basically when i type (testing) in a field it will automatically auto format the text to (TESTING). Because i have alot of text fields it is doing my head in switching from CAPS LOCK ON and CAPS LOCK OFF.

Can someone please help.

Thankyou

 

[Wayne Morgan]

You can do this with the Format property of the control, just set the Format
to >. However, this won't actually capitalize the data, it will just make it
that way when you look at it. To actually change the data, in the
AfterUpdate event of the control try:

Me.ActiveControl=UCase(Me.ActiveControl)

--
Wayne Morgan
Microsoft Access MVP

On my form i have several fields that i want to auto capitalize. Basically

when i type (testing) in a field it will automatically auto format the text
to (TESTING). Because i have alot of text fields it is doing my head in
switching from CAPS LOCK ON and CAPS LOCK OFF.