Results 1 to 3 of 3

Thread: input mask for surname and first name

  1. #1
    Join Date
    Aug 2006
    Posts
    9

    input mask for surname and first name

    Hi all,
    I'm trying to create my table in design view(MS ACCESS 2010). In Field Properties, I click on the ellipse for creating the input mask, the wizard pops up, but I'm only getting samples for zip codes, dates, etc. no name samples. How can I create a mask that is 30 characters long, upper case? Obviously, most last names aren't going to be 30 characters long, but I can't seem to create one properly.

    Thanks in advance
    Randy

  2. #2
    Join Date
    Nov 2012
    Posts
    1

    To Make text Uppercase

    If you put the data entry form into design mode.
    eg.On the field that holds the FirstName, on the Event - AfterUpdate, put the code

    me.FirstName = UCase(me.firstName)

    this will convert the text to Upper Case

    - Replace "FirstName" with your field name

    Kind Regards
    Helen Burns

  3. #3
    Join Date
    Aug 2006
    Posts
    9
    Thx Helen. I finally figured it out - by accident!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •