Connecting Tech Pros Worldwide Forums | Help | Site Map

Formatting phone number in Access Report

Newbie
 
Join Date: Sep 2006
Posts: 5
#1: Sep 20 '06
I have a report with the following paragraph:
="This BA presents a " & [EffectName] & " determination for the " & [CommonName] & " and associated habitat. We would appreciate you processing the biological opinion by " & [AdvancPlanDate] & ". If you have any questions, please contact ODOT Biologist " & [RegContact] & ", " & [ContPhone] & ", " & [RegEmail] & ". "

The problem is that the phone number [ContPhone] is showing up without any formatting, even though I saved it to the underlying table with the formatting. Since I can not select just the field in the paragraph, it will not allow me to apply formatting to it in the report.

Any ideas???
Thanks, Denise

msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,886
#2: Sep 21 '06

re: Formatting phone number in Access Report


="This BA presents a " & [EffectName] & " determination for the " & [CommonName] & " and associated habitat. We would appreciate you processing the biological opinion by " & [AdvancPlanDate] & ". If you have any questions, please contact ODOT Biologist " & [RegContact] & ", " & Format([ContPhone],"000-000-0000") & ", " & [RegEmail] & ". "
Newbie
 
Join Date: Sep 2006
Posts: 5
#3: Sep 21 '06

re: Formatting phone number in Access Report


Quote:

Originally Posted by mmccarthy

="This BA presents a " & [EffectName] & " determination for the " & [CommonName] & " and associated habitat. We would appreciate you processing the biological opinion by " & [AdvancPlanDate] & ". If you have any questions, please contact ODOT Biologist " & [RegContact] & ", " & Format([ContPhone],"000-000-0000") & ", " & [RegEmail] & ". "


Perfect. Thanks so much. Couldn't find anything anywhere that referenced the problem.

dcyale
Reply