How do I test if a field begins with a letter A-Z 2

[colezpapa3]

I want to test the first character in a field if its one of the letters of the alphabet...I forgot how to do this...

If Left(field,1) = "A" Or Left(field,1) = "B" ...etc.
Without writing all the code...

 

[Golom]

c = UCase(Left(field,1))
If c >= "A" AND c <= "Z"

 

[colezpapa3]

Thanks much.

 

[PHV]

Another way:
If field Like "[A-Z]*" Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Ed2020]

PHV,

I didn't know you could do that! Have a star for that one.

Ed Metcalfe.

Please do not feed the trolls.....