Re: Validation rule for 1 capital letter?

I think you'd use something like...

Left([somecontrol],1) = UCase(Left([Somecontrol],1))



I have not tested that though.

--
Rick B



"BBoller" <BBoller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3BE2C89A-6A32-418E-9DD9-A51C93EE11A5@xxxxxxxxxxxxxxxx
> 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

  • Validation rule for 1 capital letter?
    ... I have a colleague who is ... attempting to set up a Validation Rule so that the first letter in the field ... that an error message is received if the capital letter is not entered. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Creating an object during runtime
    ... My apologies for poor coding structure / lack of comments, ... > I'm am a bit lost on how to work it out. ... Please don't start variable names with a capital letter. ...
    (comp.lang.java.programmer)