Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

field formatting XXX-XX-XXXX

Status
Not open for further replies.

jmorlock

Programmer
Apr 25, 2003
46
US
I want to format a field for entering in a social security number so that it automatically puts the hyphens in. XXX-XX-XXXX in the input mask puts the hyphens in the text box but when you save it to the database it only saves the numbers and not the hyphens. how do I get it to save both??
 
In the field format itself use:
=Format([SSN],"000-00-0000")

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top