Input Mask

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
 
F

fredg

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

fredg

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;_
 
Top