Input Mask question

[Powderfinger]

When I use the wizard to create an input mask for a phone number field I get
!\(999") "000\-0000;0;_
or
!\(999") "000\-0000;;_

The former happens if I specify storing the data with the symbols, the
latter if I specify storing without the symbols. My question is , why do I
see it sometimes specified like this
!\(999") "000\-0000;1;_

What is the difference between the a 0 or 1 being in that last place?

Also, what does pound (!) symbol do for me. I removed it and saw no
difference although it is supposed to "Causes the input mask to display from
right to left, rather than from left to right."

 

[Linq Adams via AccessMonster.com]

It's just like leaving a function's parameter blank, it defaults to a certain
value, in this case 1.

 

[Powderfinger]

It's just like leaving a function's parameter blank, it defaults to a certain
value, in this case 1.

Thanks. That makes sense. I tried it out. Putting a 1 there is the same as
putting nothing. It will not store the symbols with either.

Any clue on my second question about the ! ?