Format Mask - SSN & Phone Numbers
422673Jun 3 2004 — edited Jun 3 2004I've created a 'report with links to form on a table (2 pages)' that has input/edit fields. Some of the fields require that users submit their social security number and/or phone number. I'm trying to create a format mask that will have the dashes embedded in the text field to complete this task (e.g. 000-00-0000 or (000)-000-0000) so that the user doesn't have to include dashes -/() in their data entry. Can someone give me an example of how to go about doing this task. Currently I have just one text field that captures SSN and phone number. Because this is how the table structure was developed. Do I need to break this field out into three fields for SSN and two fields for phone number? Any help would be greatly appreciated. Thanks.