Custom Mask

[Guest]

I need a input mask for a field in my table to be: xxx-xx-xx where the user
enters in numbers for the x's. So an example would be 132-45-66. Is there
any way that I can create a mask for that field so that the user only has to
enter in 1324566 and it reformats it to 132-45-66. Also, it needs to not
allow a user to add more than 7 numbers. Any help would be great. TIA!

 

[fredg]

I need a input mask for a field in my table to be: xxx-xx-xx where the user
enters in numbers for the x's. So an example would be 132-45-66. Is there
any way that I can create a mask for that field so that the user only has to
enter in 1324566 and it reformats it to 132-45-66. Also, it needs to not
allow a user to add more than 7 numbers. Any help would be great. TIA!

The field datatype must be Text.
000\-00\-00;0;_

The hyphens will actually be stored with the data.