Results 1 to 3 of 3
  1. #1
    ussmex is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2021
    Posts
    3

    Text Box Input Mask Not Behaving as Expected - SQL Server Back End

    Greetings,

    INTRO


    I'm using an Access front end with an Azure SQL Server back end. In the past, in separate text boxes for the phone and extension, I've successfully used input masks to present phone numbers/extensions as: (321) 555-1212 x321.

    For reasons I won't bore you with, I'm attempting to store phone+extension as raw data in one SQL Server column. For example, a phone + extension that is to appear to users on the Access form as (321) 555-1212 x321 is to be stored as 3215551212321.

    Using the !\(999") "000\-0000;0;0;# input mask, I am successful in displaying the first ten digits of output appear as expected → (321) 555-1212.

    PROBLEM TO BE SOLVED
    I have failed, however, to display the digits subsequent to the first ten digits as "x321".

    For example, I have tried the input mask !\(000") "000\-0000 x9999999;;#
    but that displays as shown in the attached image below. The yellow highlight shows how that results in (7) #'s before the number starts.

    Click image for larger version. 

Name:	Input Mask.jpg 
Views:	16 
Size:	57.6 KB 
ID:	45491

    Every input mask variation I've tried that adds an attempt to mask the extension has resulted in the same failure.

    If anyone knows the input mask that will provide the (321) 555-1212 x321 format for varying length numbers (up to 17 digits) please let me know.

    Thank you!

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,131
    It's because you are displaying characters right to left (the ! character), remove that and it works OK

  3. #3
    ussmex is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2021
    Posts
    3
    Ha! That's hilarious. I tried it previously without the "!" and received the same, poor results.

    I tried it this time and it worked. Ajax, my day just got better. Thank you.

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

Similar Threads

  1. Replies: 2
    Last Post: 01-04-2016, 04:44 AM
  2. Input Mask
    By kdbailey in forum Access
    Replies: 4
    Last Post: 12-19-2014, 08:11 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. Recordset not behaving as expected
    By jgelpi16 in forum Programming
    Replies: 4
    Last Post: 02-15-2011, 04:25 PM

Tags for this Thread

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