Results 1 to 5 of 5
  1. #1
    Benlav is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    6

    Input mask using the wrong character...

    Hi all,



    A slightly confusing one here. I have bank account numbers in my tables. The input mask is ##-####-#######-### (that is the format of our bank account numbers). It works fine for me, however, when my users access the reports and userforms, they see ##/####/#######/###.

    It's not the end of the world, as it is a separator none the less, but it is unusual and might be an easy fix?

    Thanks,

    Ben

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Maybe the textboxes holding those fields should be wider. Your user may have a different screen resolution on their computers than you do.

  3. #3
    Benlav is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    6
    Sorry for missing this earlier. I've just looked at the database on one of the end users PC. Even the database tables show ##/####/#######/### instead of ##-####-#######-###. This is so weird.

  4. #4
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    Typ tekst of een websiteadres of vertaal een document.
    Annuleren


    Vertaling voor - is een tekenVertaal in plaats daarvan naar - is een teke

    - is a sign that depends on the windows country settings.
    Put a \ before each -

  5. #5
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    You need to verify that there is no format setting for the bank account field in the forms and reports AND the tables. That might explain why you see "/" instead of "-".

    Also, in the input mask for the bank account number - did you ensure that you have included the second part of the mask property, and set it to 0? If you do not include that second part, or set it to non-zero, the literal characters - the dashes in your case - in the mask are NOT stored with the data in the table (check the help file for details).

    The mask should look like this: ##-####-#######-###;0

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 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