Results 1 to 3 of 3
  1. #1
    bonfire00 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    1

    Access Input Mask Help


    I have a serial number field and the first six digits are always the same, so I wanted to create a mask to only enter the last 6 digits and it fill in the first six. However the first six are 400053 and the 0's will not stay 0's, but act as the place holder for the other digits. Is there a way for it to this? I need 400053######

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,522
    I would ignore the mask and leave off the 400053.
    put the 400053 in a locked text box next to the entry text box.
    the user need only enter their #, but the AfterUpdate event would put them together in the fields.

    txtField = txtPre & txtEntry

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I need 400053######
    I just made an input mask using
    4\0\0\053######;0

    The backslash makes the first 3 zeros literal characters that get stored.
    See "Input Mask" in help

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

Similar Threads

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