Results 1 to 3 of 3
  1. #1
    PRHoff is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    7

    Input Mask

    I'm still a new user to Access so please bear with me.I am trying to create a custom input mask using both text and numeric characters for a form.


    Example would me ABCD-12345678. However the first 4 letters would would need to be able to change.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    if the letters and numbers are required and the length is always the same (4 digits/8 digits) it would be something like:

    LLLL-00000000

    If the digits are optional it would be more like

    LLLL-99999999

    See this for more:

    https://support.office.com/en-us/art...2-4a47832de8da

  3. #3
    PRHoff is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    7
    Thank you, that solved it!

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

Similar Threads

  1. Input Mask
    By kdbailey in forum Access
    Replies: 4
    Last Post: 12-19-2014, 08:11 AM
  2. Input mask
    By scorpion99 in forum Access
    Replies: 4
    Last Post: 02-21-2014, 02:18 AM
  3. input mask
    By slimjen in forum Forms
    Replies: 7
    Last Post: 10-07-2013, 03:20 PM
  4. Input Mask
    By qbc in forum Access
    Replies: 2
    Last Post: 01-20-2012, 03:27 PM
  5. Input mask
    By doobybug in forum Access
    Replies: 2
    Last Post: 06-17-2009, 09:40 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