Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Guatemala City
    Thanked 0 Times in 0 Posts

    Input mask in Access table - the ! (Win XP Access 2003)

    In Help on the Input Mask, I don't understand what the ! does. The example I am using is !(999") "000-0000 from the Input Mask Wizard. I had expected to be able to enter a telephone number without an area code, without having to enter spaces, but that isn't the case. What does it do, please.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Input mask in Access table - the ! (Win XP Access 2003)

    According to the online help, the exclamation mark
    <hr>Causes the input mask to display from right to left, rather than from left to right. Characters typed into the mask always fill it from left to right. You can include the exclamation point anywhere in the input mask.<hr>
    If you have an input mask (999), and if you enter only a 5, you will see <code>(5 )</code>. If the input mask is !(999), you will see <code>( 5)</code>. The single character you entered is right-aligned within the parentheses if the input mask contains an exclamation mark. This seems of very limited usefulness to me, but then I dislike input masks in general.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts