Capitol Letters

[acss]

How does one ensure that regardless if the user types into the forms small
cap on text, the text will always be large cap. I inserted the > into the
field which converts the small cap to large but it ends up in the table as
small. What can be done?

 

[fredg]

How does one ensure that regardless if the user types into the forms small
cap on text, the text will always be large cap. I inserted the > into the
field which converts the small cap to large but it ends up in the table as
small. What can be done?

If you must store the data in caps (why?) then:
Let the user enter the text normally.
Code the control's AfterUpdate event:

Me![ControlName] = UCase([ControlName])

All caps is considerably more difficult to read. Perhaps you should
re-think storing the data this way.
Store the text as normal type. If you then need all caps (in a report
Shipping Label, for example) just use an unbound control. Set it's
control source to = UCase([FieldName]). That will show all-caps, but
elsewhere the same data will be normal size print.

 

[acss]

Thanks, that did it.

In the KeyPress event of the text box eneter -

KeyAscii = Asc(UCase(Chr$(KeyAscii)))

HTH

Peter Hibbs.

 

[Peter Hibbs]

In the KeyPress event of the text box eneter -

KeyAscii = Asc(UCase(Chr$(KeyAscii)))

HTH

Peter Hibbs.