Access 97 – Formatting Phone Numbers

To format a phone number in Microsoft Access Visual Basic, you can use this code:

IIf(Len([TableName]![Home Phone])=10,Format([TableName]![Home Phone],”(@@@) @@@-@@@@”),Format([TableName]![Home Phone],”@@@-@@@@”))