Results 1 to 2 of 2
  1. #1
    neo651 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    110

    Input Mask Optional Separators?


    I'm creating a form for a table of license keys and I want to use an input mask to add hyphens to make the keys easier to read, but the license keys are all different lengths. I'm wondering if there's a way to tell access that once there are no more characters to stop displaying the separators. Otherwise I end up with either a mess of unseparated characters at the end or a series of superfluous hyphens (except for when the license key happens to be the correct length for whatever input mask I designed).

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    I doubt it. The very nature of input mask demands consistency of structure. I expect you will just have to require users to type hyphens and not use input mask.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Input Mask
    By Serge-Nanaimo in forum Access
    Replies: 10
    Last Post: 02-15-2017, 09:10 PM
  2. Input Mask
    By warmanlord in forum Access
    Replies: 11
    Last Post: 10-15-2015, 10:01 AM
  3. Input Mask
    By kdbailey in forum Access
    Replies: 4
    Last Post: 12-19-2014, 08:11 AM
  4. Input mask
    By scorpion99 in forum Access
    Replies: 4
    Last Post: 02-21-2014, 02:18 AM
  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