Re: Validation rule for 1 capital letter?

Why? If the only purpose of the validation check is to tell the user s/he
didn't capitalize the first character, why not just capitalize the first
character for him/her, no matter what?

Regards

Jeff Boyce
<Access MVP>

"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

  • Re: Validation rule for 1 capital letter?
    ... If the only purpose of the validation check is to tell the user s/he ... > didn't capitalize the first character, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Entry stops validating after insertion
    ... my $string = shift; ... The deleteseemed to stop validation. ... sub capitalize { ...
    (comp.lang.perl.tk)
  • Re: NewLine bug of Windows Speech Recognition revisited
    ... What program are you dictating in where the New Line command does not start ... New Line with a capital letter. ... but at least they had the common sense _not_ to capitalize ... the first word of each New Line by default, ...
    (microsoft.public.windows.vista.general)
  • Re: NewLine bug of Windows Speech Recognition revisited
    ... What program are you dictating in where the New Line command does not start ... New Line with a capital letter. ... but at least they had the common sense _not_ to capitalize ... the first word of each New Line by default, ...
    (microsoft.public.windows.vista.general)
  • Re: Auto Capilization
    ... Word does not capitalize automatically when a sentence ends with a number or when a period is followed by other punctuation, such as quotation marks. ... If it is the client who is typing, then he will have to accept that he has to use the Shift key. ... not start with a capital letter. ...
    (microsoft.public.word.docmanagement)
Loading