Validation rule for 1 capital letter?



Hi all - apologies if this is a stupid question! I have a colleague who is
attempting to set up a Validation Rule so that the first letter in the field
must be a capital letter. He wants to use that rather than an input mask so
that an error message is received if the capital letter is not entered. I
have looked around for something similar and being (admittedly) new to the
idea of Validation rules, I'm stuck. Can anyone offer any suggestions?

Thank you!
.



Relevant Pages

  • Re: Validation rule for 1 capital letter?
    ... BBoller wrote: ... > I have a colleague who is ... > attempting to set up a Validation Rule so that the first letter in the field ...
    (microsoft.public.access.tablesdbdesign)
  • validation rule for text field
    ... I need a validation rule for test field containing first ... and last names that will force the first letter of both ... first and last name to upper case and all other letters to ...
    (microsoft.public.access.queries)
  • Re: Validation rule for 1 capital letter?
    ... > Hi all - apologies if this is a stupid question! ... > attempting to set up a Validation Rule so that the first letter in the ... > that an error message is received if the capital letter is not entered. ...
    (microsoft.public.access.tablesdbdesign)