Adding brackets and dashes to a string 1

[AZgolfer1]

Hello,
Does anyone know how to add brackets and dashes to a string representative of the area code and phone number? The string has all the numbers combined and I would like to add brackets around the area code and then add a dash in the phone number.

Thanks,

 

[CaptainD]

The easy way is to set the input mask property for the text box to phone number

 

[TheAceMan1]

How are ya AZgolfer1 . . .

For existing numbers an update query should do!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[TheAceMan1]

How are ya AZgolfer1 . . .

For existing numbers an Update Query should do! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[CaptainD]

If you do need an UPDATE query for existing data, try something like this.

UPDATE tPhoneNumbers
SET PhoneNumber = "(" + LEFT(phoneNumber,3) +")" + " " + MID(PhoneNumber,4,3) + "-" + MID(PhoneNumber,6,4);

 

[AZgolfer1]

Thanks to both of you. I have fixed the issue.