Print Partial Phone Number (Access 2000 (9.0.4402) SR-1)

Topic

New Reply

Print Partial Phone Number

Using Access 2000 (9.0.4402) SR-1

I have phone number defined as follows:

StrPhone Text !(999

Reply | Quote

Replies

Try this: Format(Right([PhoneNumber],7),”000-0000″)

Reply | Quote

Is that an input mask for the table field or for a form control? Is the data actually saved with the additional characters or without? If the formatting is NOT saved, then it’s easy to simply use the Right() function to return the value and the Format() function to apply the formatting you want.

Format(Right(strPhone,7),”@@@-@@@@”)

If the formatting is saved, just use the Right function like this:

Right(strPhone,8)

Reply | Quote