Upper Case Words

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

Guest

In our dB someone enter descriptions in capital letters. I need to Identify
those entry. How can I do that?
 
Type this into the Field row in query design:
StrComp([MyField], UCase([MyField]), 0)

Substitute your field name for MyField.

In the Criteria row under this, enter a zero.
 
It worked perfectly.
Thanks


Allen Browne said:
Type this into the Field row in query design:
StrComp([MyField], UCase([MyField]), 0)

Substitute your field name for MyField.

In the Criteria row under this, enter a zero.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Eugene said:
In our dB someone enter descriptions in capital letters. I need to
Identify
those entry. How can I do that?
Click to expand...
Click to expand...
 
Back
Top