Text Box Formatting

[sarge97]

I use Social Security Numbers on most of my reports but the format must be screwed up!!!! An example would be 123-45-6789, It always comes out 123-4-5-6789. I've checked all the way back to the table design but can't fiqure it out????

Thanks for any help-Sarge

 

[dhookom]

It might help if you told us exactly how the value is being stored and what Input Masks and Formats you are using.

I would not ever use either an input mask or a format on any text box that was used for entering a social security number.

I assume you are using a text field to store this value.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.