Format mask specialist needed

[1jet]

Hi all,

I need a custom format mask as follows...
xxx-xxx-xxx
where x is a number only.

This format mask will be used for a textbox that will input the number into a table.

What is the best data type to be able to save this number?

And I also need to keep in mind that when I retrieve this number, it'll have to be in the same format as above.

 

[KenHigg]

Something like:

000\-000\-0000;0;_

???

 

[1jet]

Yes thats exactly what I was looking for.
Cheers

I've also changed the table's data type to text from number.

I guess as long as I keep the input mask on the necessary forms I'll be OK.

Thanks again

 

[KenHigg]

You could put it at the table level...