Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    6

    can a field have 2 different input masks


    I am wondering if it is possble to have 2 different inputs masks depending is the field starts with a YO.

    Is something like this possible?

    IF left(nz([fieldname],vbnullstring),2)="yo"
    THEN input mask = "LLL00000-0000"
    ELSE
    input mask = "LL00000-0000"
    ENDIF

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    How about just an input mask of: ?LL00000-0000

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Input mask
    By doobybug in forum Access
    Replies: 2
    Last Post: 06-17-2009, 09:40 PM
  2. Input limits
    By Hannu in forum Access
    Replies: 0
    Last Post: 08-31-2008, 03:02 AM
  3. Database Form Input Masks
    By scartmell in forum Forms
    Replies: 1
    Last Post: 08-12-2008, 01:20 PM
  4. Textbox will not allow input
    By cwf in forum Forms
    Replies: 0
    Last Post: 04-04-2008, 04:08 PM
  5. Input parameters
    By GloriaLuz in forum Reports
    Replies: 0
    Last Post: 11-14-2005, 09:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums