Input Mask

  • Thread starter Thread starter q
  • Start date Start date
Q

q

Hi

We want to create an Input Mask for a telephone number that has a prefix
already populated.

Eg (07) 1234-5678

The use of "0" is a problem here as the wizard assumes it to be null.

Any assistance would be appreciated
 
Hi

We want to create an Input Mask for a telephone number that has a prefix
already populated.

Eg (07) 1234-5678

The use of "0" is a problem here as the wizard assumes it to be null.

Any assistance would be appreciated
Click to expand...

As long as you do not need to change the prefix:
"(07) "000\-0000;;_
The field datatype should be Text.
 
As long as you do not need to change the prefix:
"(07) "000\-0000;;_
The field datatype should be Text.
Click to expand...

I forgot to add:
To save the mask with the data use:
"(07) "000\-0000;0;_
 
Back
Top