Format Phone Numbers A2000

D

David

I'm having trouble getting the dash into the phone number on a report. The
text box control source is:
="My phone number is (" & [AreaCode] & ") " & [Telecom] & "."
Since the dash isn't stored with the phone number, I need to get tit in
there somehow. I've tried stuff like
Format([Telecom],000-0000)
but that doesn't work, and I can't find detailed Help on the Format
function. Any help would be greatly appreciated!
David
 
F

Fredg

David said:
I'm having trouble getting the dash into the phone number on a report. The
text box control source is:
="My phone number is (" & [AreaCode] & ") " & [Telecom] & "."
Since the dash isn't stored with the phone number, I need to get tit in
there somehow. I've tried stuff like
Format([Telecom],000-0000)
but that doesn't work, and I can't find detailed Help on the Format
function. Any help would be greatly appreciated!
David
Click to expand...
One way is to use an unbound control.
As long as the area code is in it's own field set
it's control source to:

=Left([PhoneField],3 & "-" & Right([PhoneField],4)
 
Top