"All Caps" Validation rule

[Bill Lentz]

I have the following validation rule for a field:

Like "[A-Z][A-Z][A-Z]"

How do I modify this to require that the entry be in uppercase?

Thanks
Bill

 

[Al Camp]

Bill,
Have you considered just formatting the field to always
"display" in caps... using the > in the Format property?
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Arvin Meyer]

It's much easier just to force the result to all caps. In the text box's
AfterUpdate event, just add code similar to the following:

Sub txtWhatever_AfterUpdate()
Me.txtWhatever = UCase(Me.txtWhatever)
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access