Can you force memo or text fields to only allow capitalization

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top