Make all Fields Upper Case Using Code

[ABinBoston]

I have an application that formats the data normally, but one client wants the
option to change all fields to Upper case.

I would like to make all fields Upper Case using code if an option to do so is
selected in a Config table.

Any help is appreciated

AB

 

[AlCamp]

AB,
Do you want to store the data in upper case, or just "see" the data as
upper case.
An Update query with Ucase(MyField) will alter the stored data to
uppercase, and for data entry thereafter, on the AfterUpdate event for every
field, MyField = Ucase(MyField) will force the entry into upper case.
If you just want to see the upper case data, then a...in the format property would display any data as uppercase.

hth
Al Camp

 

[ABinBoston]

What I would like to do is allow an option in a setup form to either display
All Caps or display the data as it normally does as the default.

If I use the > to format the fields and a user does not want All Caps, then to
turn it off I need to go into every field again. The idea is to be able to
"toggle" this option.

Thanks - AB