Automatic Capital Letters in a Form Help

[zishan619]

Hi everyone:
I have a form and I want when an analyst types in the textbox that the words are capital letters. Is there a way to do that without having to tell them to place there caps lock on the keyboard.
Thanks
Zishan

 

[Kherozen]

I'm not to sure in which On_event(maybe the On Enter of the control) who should put this but
to uppercase a text just do the following code
Me![yourControl] = UCase(Me![yourControl])

jul ^_^

 

[AlienRay]

I would do it on the On Exit event. The user can type in whatever case they like, but it will convert to Upper Case when they leave the field.

 

[idd]

ZiShan,

There is a way to do that,

just place a > in the format property of the field in the table and the same in the format property of the text box in the form and it should do the trick.

having it only in the form will display as caps, but will store as lower case, having it in the table o=alone will store as caps but display as it was entered, having it in both will display and store as caps.

for more information on this place your cursor in the INPUT MASK propeerty in the table design view and press f1, this should bring up help on this topic.


idd

 

[zishan619]

Thank You everyone it worked on the Exit Event and also The > Symbol worked as well. Thanks
Zishan

 

[idd]

What Kherozen mentioned works too, as a replacement for a > being placed in the text box on the form, however it will still store the data in lowercase.


You can place that code on the before update, after update and on Exit events

idd

 

[idd]

Whoops I was I was probably writing my last message when zishan was also writing confirming that they work.

Idd