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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

From large to small letters 4
Upper Case 2
Access Automatically Send a notification email once a record is added 0
How to query a text string when case is in upper and lower 3
Insert spaces into String 5
Upper/Lower case query 4
How to change sentence in Caps to upper & lower case 3
Upper Case Conversion 3

Back
Top