Phone Number Look-up Format

[wizcow]

Hi

On my Invoice form I have 2 hidden look-up text boxes.

'CPhone' looks up the client's phone number.
'CExt.' looks up the client's extension number.

In the client's info section I have a visible text box that uses this control source;
="phone " & [CPhone] & " " & [CExtension]

This works well, in that it brings up the phone number and extension, if there is one. If there is not, then nothing shows.

My problem is that the phone number comes up like this
5555555555
I want it to look like this
(555) 555-5555

Tom

 

[WayneRyan]

wizcow,

txtWhatever = Format(OldPhone, "(999)999-9999")

Then display txtWhatever.

hth,
Wayne

 

[wizcow]

Wayne I'm not sure how to administer this code.
Could you give me a few more instructions? I'm still learning.

Tom

 

[shay]

Put this is the control source of your text box:

="phone " & format([CPhone], "(000) 000-0000") & " " & [CExtension]

hth

shay

 

[wizcow]

Thanks.
That works great!

Tom