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