Applies to memo and text fields...
You can choose to store your data in upper case, or... store the text in any
form, but always "display" the data in upper case.
To Store your data as upper case, for each text or memo field, on the
AfterUpdate event...
[YourFieldName] = UCase([YourFieldName])
To always just display the text and memo as upper case, use the > symbol in
the format of the text or memo field.
Be advised... that text in all caps (especially memo fields with lots of
text) can be very "busy" and tiring to read.
hth
Al Camp
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.