Upper case problem.

[Sue]

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

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.

 

[Larry Daugherty]

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

 

[Sue]

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

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