I am using Access 2007. I have an input form that collect SS#'s with an input mask and saves it in a text field. The contents of the text field is 123456789 for example.
The report field format property but does not have any syntax examples.
I would guess it would be something like 999-99-9999 but that doesn't work.
What is the syntax to enter in the format property of the text box on a report to take 123456789 from the table and display it as 123-45-6789?
Thanks in advance for your help.