Unbound text box

T

theitman

Hello. I am using reports to create form letters and I am running into a
snag. Withing one of the text box, I need to put quotes around one word.
Here's my text box control source. I need to put quotes around the word
insured. Any ideas would be appreciated!
Thanks

="The policy of insurance issued to our insured does have the benefit of
medical payments coverage. However, this policy excludes coverage if the
insured has other collectible insurance. Please forward any medical bills to
our insured's health insurance for their handling." & NL() & NL() & "Our
company will consider any unpaid balances upon receipt of the explanation of
benefit forms showing what the accident and health insurance has or has not
paid." & NL() & NL() & "The policy exclusion states:" & NL() & NL() & "We do
not provide Medical Payments Coverage for any insured for bodily injury:" &
NL() & "12. To the extent that medical or dental expenses are payable
under:" & NL() & " a. Any other medical payments insurance; or" & NL() &
" b. Any form of accident or sickness insurance" & NL() & NL() & "If
there are any questions, please contact me at 1-800-242-9703." & NL() & NL()
& Trim([ILLINOISSENTANCE]) & NL() & "Sincerely," & NL()+NL()+NL()+NL() &
UCase([Inside Adjuster Name] & " " & [Subtitle] & " "+NL() &
Trim([Title]))+NL()+NL() & "Enclosure" & Trim([cc1])+NL() & Trim([cc2])+NL()
& Trim([cc3])
 
B

Brendan Reynolds

To embed quotes within a string expression, double them. For example ...

="The ""insured"" person"
 
D

Duane Hookom

You can try double quotes within the string:
="This text should be in ""quotes"" followed by this".
 
T

theitman

Thanks, it worked awesome!

Brendan Reynolds said:
To embed quotes within a string expression, double them. For example ...

="The ""insured"" person"

--
Brendan Reynolds

theitman said:
Hello. I am using reports to create form letters and I am running into a
snag. Withing one of the text box, I need to put quotes around one word.
Here's my text box control source. I need to put quotes around the word
insured. Any ideas would be appreciated!
Thanks

="The policy of insurance issued to our insured does have the benefit of
medical payments coverage. However, this policy excludes coverage if the
insured has other collectible insurance. Please forward any medical bills
to
our insured's health insurance for their handling." & NL() & NL() & "Our
company will consider any unpaid balances upon receipt of the explanation
of
benefit forms showing what the accident and health insurance has or has
not
paid." & NL() & NL() & "The policy exclusion states:" & NL() & NL() & "We
do
not provide Medical Payments Coverage for any insured for bodily injury:"
&
NL() & "12. To the extent that medical or dental expenses are payable
under:" & NL() & " a. Any other medical payments insurance; or" &
NL() &
" b. Any form of accident or sickness insurance" & NL() & NL() & "If
there are any questions, please contact me at 1-800-242-9703." & NL() &
NL()
& Trim([ILLINOISSENTANCE]) & NL() & "Sincerely," & NL()+NL()+NL()+NL() &
UCase([Inside Adjuster Name] & " " & [Subtitle] & " "+NL() &
Trim([Title]))+NL()+NL() & "Enclosure" & Trim([cc1])+NL() &
Trim([cc2])+NL()
& Trim([cc3])
Click to expand...
Click to expand...
 
T

theitman

Thanks, it worked awesome!

Duane Hookom said:
You can try double quotes within the string:
="This text should be in ""quotes"" followed by this".

--
Duane Hookom
MS Access MVP
--

theitman said:
Hello. I am using reports to create form letters and I am running into a
snag. Withing one of the text box, I need to put quotes around one word.
Here's my text box control source. I need to put quotes around the word
insured. Any ideas would be appreciated!
Thanks

="The policy of insurance issued to our insured does have the benefit of
medical payments coverage. However, this policy excludes coverage if the
insured has other collectible insurance. Please forward any medical bills
to
our insured's health insurance for their handling." & NL() & NL() & "Our
company will consider any unpaid balances upon receipt of the explanation
of
benefit forms showing what the accident and health insurance has or has
not
paid." & NL() & NL() & "The policy exclusion states:" & NL() & NL() & "We
do
not provide Medical Payments Coverage for any insured for bodily injury:"
&
NL() & "12. To the extent that medical or dental expenses are payable
under:" & NL() & " a. Any other medical payments insurance; or" &
NL() &
" b. Any form of accident or sickness insurance" & NL() & NL() & "If
there are any questions, please contact me at 1-800-242-9703." & NL() &
NL()
& Trim([ILLINOISSENTANCE]) & NL() & "Sincerely," & NL()+NL()+NL()+NL() &
UCase([Inside Adjuster Name] & " " & [Subtitle] & " "+NL() &
Trim([Title]))+NL()+NL() & "Enclosure" & Trim([cc1])+NL() &
Trim([cc2])+NL()
& Trim([cc3])
Click to expand...
Click to expand...
 
Top