Home Code Access 97 – Formatting Phone Numbers

Access 97 – Formatting Phone Numbers

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

Previous articleBlock meta refresh redirects in FireFox 56+
Next articleServer 2012r2 Install-Module SecMgmt – not recognized install issues resolved

LEAVE A REPLY

Please enter your comment!
Please enter your name here