validation rule for text field

operations_at_topshelfnutrition.com
Date: 03/19/05 

Date: Sat, 19 Mar 2005 14:33:18 -0800

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
lower case. I am learning but have not been able to figure
this out. I also need a similar validation rule to do the
same with individual test fields for each of first and last
name. Can anyone help me with this?
Thank you
Betty

Relevant Pages

  • Re: validation rules
    ... a test field. ... need the validation rule to specify that the user can only enter a 4 digit ... >>saying that there is a type mismatch in the form controls validation property! ...
    (microsoft.public.access.formscoding)
  • Re: validation rules
    ... Oops, sorry I meant the field is a TEXT field not a test field ... "AMHodgetts" wrote: ... > need the validation rule to specify that the user can only enter a 4 digit ...
    (microsoft.public.access.formscoding)
  • 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: 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)
Loading