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!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validation Rule Expression for Upper Case?

Status
Not open for further replies.

ATAIntern

Programmer
Feb 20, 2001
7
0
0
US
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 (-:
 
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
 
Jeez, I used to know that! I think I've forgotten it several times, in fact.

Thanks very much, karatekid!
sheepish ATAIntern:-Q
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top