auto capitalise text fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


djmatrix said:
On my form i have several fields that i want to auto capitalize. Basically
Click to expand...
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.
 
Back
Top