Phone Number Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here's my question. I am using reports for form letters and so far they have
been working great. I am using unbound text boxes for the body of the letter
and using things such as & [Agent Name] & "is scheduled to " etc.... Where
[Agent Name] is a field in a table and everything between " " is text that
will always be in the letter. Anyway, I have a phone number field that I
need to add to one of the form letters. Problem is, it shows up like
8005559683 in the form letter. Is there anyway to format this within the
unbound text field to look like 800-555-9683?
Thanks!
 
I still can't get it to work. Here is what is located in my unbound text box
in my report. I need [misc text2] to be formatted as a phone number.
Thanks

unbound text box:
="As was discussed today we have assigned your storm claim to a field
adjuster for inspection." & NL() & NL() & "This adjuster is " & UCase([MISC
TEXT]) & ". This adjuster can be reached at " & [MISC TEXT2] & ". If you
haven't heard from the adjuster by the time you receive this letter please
call them to schedule an inspection of your property." & NL() & NL() &
Trim([ILLINOISSENTANCE]) & NL() & NL() & "Sincerely," &
NL()+NL()+NL()+NL()+NL() & "Dave Weiler" & NL() & "Property Claims Supervisor
" & NL()+NL()+NL()+NL() & "cc: AGENT# " & [Agent Number] & " " & [Misc
Text8] & NL() & Trim([cc1])+NL() & Trim([cc2])+NL() & Trim([cc3])

SusanV said:
me.textbox = me.textbox(Format "000-000-0000")

--
hth,
SusanV

theitman said:
Here's my question. I am using reports for form letters and so far they
have
been working great. I am using unbound text boxes for the body of the
letter
and using things such as & [Agent Name] & "is scheduled to " etc....
Where
[Agent Name] is a field in a table and everything between " " is text that
will always be in the letter. Anyway, I have a phone number field that I
need to add to one of the form letters. Problem is, it shows up like
8005559683 in the form letter. Is there anyway to format this within the
unbound text field to look like 800-555-9683?
Thanks!
Click to expand...
Click to expand...
 
If you don't already have the field LineID (or [misc Text2] or whatever the
field actually is called) embedded in your report, embed it (and set it to
not visible if you like). Let's call the textbox control with the source of
LineID "txtLineID"

The code would be:

dim strLineID as String
strLineID = me.txtLineID
strLineID = Format (strLineID "000-00-000")

' Then instead of using the field from the table in your textbox message,
use the variable strLineID:

="As was discussed today we have assigned your storm claim to a field
adjuster for inspection." & NL() & NL() & "This adjuster is " & UCase([MISC
TEXT]) & ". This adjuster can be reached at " & strLineID & ". If you
haven't heard from the adjuster by the time you receive this letter please
call them to schedule an inspection of your property." & NL() & NL() &
Trim([ILLINOISSENTANCE]) & NL() & NL() & "Sincerely," &
NL()+NL()+NL()+NL()+NL() & "Dave Weiler" & NL() & "Property Claims
Supervisor
" & NL()+NL()+NL()+NL() & "cc: AGENT# " & [Agent Number] & " " & [Misc
Text8] & NL() & Trim([cc1])+NL() & Trim([cc2])+NL() & Trim([cc3])


--
hth,
SusanV



theitman said:
I still can't get it to work. Here is what is located in my unbound text
box
in my report. I need [misc text2] to be formatted as a phone number.
Thanks

unbound text box:
="As was discussed today we have assigned your storm claim to a field
adjuster for inspection." & NL() & NL() & "This adjuster is " &
UCase([MISC
TEXT]) & ". This adjuster can be reached at " & [MISC TEXT2] & ". If you
haven't heard from the adjuster by the time you receive this letter please
call them to schedule an inspection of your property." & NL() & NL() &
Trim([ILLINOISSENTANCE]) & NL() & NL() & "Sincerely," &
NL()+NL()+NL()+NL()+NL() & "Dave Weiler" & NL() & "Property Claims
Supervisor
" & NL()+NL()+NL()+NL() & "cc: AGENT# " & [Agent Number] & " " & [Misc
Text8] & NL() & Trim([cc1])+NL() & Trim([cc2])+NL() & Trim([cc3])

SusanV said:
me.textbox = me.textbox(Format "000-000-0000")

--
hth,
SusanV

theitman said:
Here's my question. I am using reports for form letters and so far
they
have
been working great. I am using unbound text boxes for the body of the
letter
and using things such as & [Agent Name] & "is scheduled to " etc....
Where
[Agent Name] is a field in a table and everything between " " is text
that
will always be in the letter. Anyway, I have a phone number field that
I
need to add to one of the form letters. Problem is, it shows up like
8005559683 in the form letter. Is there anyway to format this within
the
unbound text field to look like 800-555-9683?
Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top