Validation Rule Expression for Upper Case?

ATAIntern · Mar 1, 2001

Hi, all! My first post and, I hope, a very simple question:

What should the ValidationRule expression be for a table field (text) that I want to limit to all-uppercase letters (well, it can include a combo of letters and numbers, but the letters should be all-uppercase)?

Loving the forum and eagerly awaiting the solution,
ATAIntern (-:

CPUburn · Mar 1, 2001

Hi there,

this is a little tricky; you don't need a validation rule, but just a "format" of the table field, just enter ">" in the table's design for the specified field and all characters will be uppercase for the field
;-)
the kid

ATAIntern · Mar 1, 2001

Jeez, I used to know that! I think I've forgotten it several times, in fact.

Thanks very much, karatekid!
sheepish ATAIntern:-Q

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Validation Rule Expression for Upper Case?

ATAIntern

Programmer

CPUburn

Programmer

ATAIntern

Programmer

Similar threads

Part and Inventory Search

Sponsor