Home Code Access 97 – Formatting Phone Numbers

Access 97 – Formatting Phone Numbers

17
0

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],”@@@-@@@@”))

LEAVE A REPLY

Please enter your comment!
Please enter your name here