finding text in all caps

[thompm65]

Hello,

I would like to be able to find records that the text is in all capital letters. Is this possible? If so, how?

Thanks,

MT

[BobWeaver]

You can create a calculated field with the formula:

Exact(TextField,Upper(TextField))

This will return a value of 1 if the field "TextField" is all upper case and a value of 0 otherwise. So, all you have to do is search this calculated field for values of 1.

[thompm65]

Thanks! That worked.

MT