Upper case problem.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a field whose format is set to > and whose input mask is
set to LA0000. The form for data entry also has format for that field set to
. A query that I've designed displays this field properly, but the report
Click to expand...
does not; the characters in question are capitalized only if they were typed
that way. The text isn't "forced" to caps as I'd anticipated.

Is there somewhere within the form or the table where I can enter some code
that will case a conversion of all lowercase letters to caps both in the
form, in the table, and in all queries & reports that use this field?

Thanks.
 
In the BeforeUpdate event of each textbox you want to force to save
characters in upper case, place a line of code like:

me!MyTextbox = UCase(me!MyTextbox)

HTH
 
Thanks for the help!
--
Thanks for your time!


Larry Daugherty said:
In the BeforeUpdate event of each textbox you want to force to save
characters in upper case, place a line of code like:

me!MyTextbox = UCase(me!MyTextbox)

HTH
Click to expand...
 
Back
Top