Format Phone Numbers A2000

  • Thread starter Thread starter David
  • Start date Start date
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
 
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)
 
Back
Top