This is probably a no-no, but will ask anyway.
I have a query that occasionally people edit data on or enter data
into.
I have a field that I want to always be "caps", if they enter "yes" I
want it to be YES or "no" to be "NO". If this were on a form I can do
a "build event" under code and I have some code that works.
Unforuntately, since it's just a query, if I go into design view and
click "build" it doesn't let me do it that way. I can put in some
sort of expression, perhaps like "UCASE$"???? But I don't get how
that works.
Is there a way to make it so that if they enter something it goes in
caps in the query?
thanks,
ga
George Applegate
gappleg8@[EMAIL PROTECTED]
