Make everything Upercase

R

Ryan

I have a form that I would like everything to be uppercase on. Can someone
please tell me how to do this. For example, I have a field named
[BatchType], what code would I need to make all entries uppercase?

Thank you in advance.
 
R

Ryan

One thing I forgot to mention is that I dont want the actual data to change,
I just want it to be uppercase on the form that I print. The reason I want
this is because we use optical scanning and uppercase is easier to read, but
in every other form I want the proper case.
 
G

GH

I have a form that I would like everything to be uppercase on. Can someone
please tell me how to do this. For example, I have a field named
[BatchType], what code would I need to make all entries uppercase?

Thank you in advance.
Click to expand...

Once simple way to accomplish this is to place a greater than sign (>)
in the Format property of each text field. The user can type in any
case, but the text will convert to upper case when the text box loses
focus. Of course, although certainly a standard look, all upper case
can be hard on the reader's eyes, so a lot of this on a form might be
ugly to look at.

HTH
- GH
 
J

John W. Vinson

One thing I forgot to mention is that I dont want the actual data to change,
I just want it to be uppercase on the form that I print. The reason I want
this is because we use optical scanning and uppercase is easier to read, but
in every other form I want the proper case.
Click to expand...

If you'll be printing, print from a Report, rather than a Form. Set the Format
property of each such textbox on the report to

(just a single greater-than character). It will display (in that textbox) in
upper case.

John W. Vinson [MVP]
 
Top