Formatting issue with imported telephone number!

[JHB]

Hi:

I have an unusual situation and need some advice. I am using Access
2000 with windows XP.

I have imported client records from a spreadsheet. On that
spreadsheets, phone numbers have been formatted to the standard phone
format and this appears to import into a table with the entry mask set
to telephone format. The format holds when the field is used alone (ie
is in a report as a unique field) BUT when I concatenate as in: [Home
Address]&" Phone: "&[Home Phone], it either looses all formatting and
shows as a number, or appears in a zip code format. Can anyone suggest
a way out of this and/or offer any reason his might be happening?.
Data input directly into the phone number field goes in as a phone
number and stays that way through all processing!

Any Help appreciated

John Baker

 

[Gloops]

Hello,

You say that when using the phone number alone, it has the good format ...
So, a possible syntax is the following one :

strPhone = [Home Phone]

strFullAddress = [Home Address] & " - Phone : " & strPhone

If this is not OK, you can put the [Home Phone] field in a textbox
control named txtPhone, with a phone format input mask, and extract the
phone number that way :

strPhone = Format(txtPhone.Value, txtPhone.InputMask)

 

[JHB]

Hello,

You say that when using the phone number alone, it has the good format ....
So, a possible syntax is the following one :

strPhone = [Home Phone]

strFullAddress = [Home Address] & " - Phone : " & strPhone

If this is not OK, you can put the [Home Phone] field in a textbox
control named txtPhone, with a phone format input mask, and extract the
phone number that way :

strPhone = Format(txtPhone.Value, txtPhone.InputMask)

Thank you..