Custom Mask

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
Click to expand...

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

The hyphens will actually be stored with the data.
 
Back
Top