Two Trims in one Text Box

[Dan @BCBS]

I need to add a second =Trim in a text box on a report.
=Trim("I am writing to acknowledge receipt of your request dated " &
[DOMbrLtr] & ", received by Health Option's, Inc. (HOI) on " & [RecHOI] & ",
regarding " & [Requested] & ")

I need to replace [Requested] with =Trim(formatfield([mbr_firstname]) & " "
& formatfield([mbr_lastname]))

When I try to use a seperate text box I cannot line it up. It all needs to
be in the same text box.

How can I replace "Requested" with this string??

Thank you

 

[Jeff Boyce]

In either the textbox's Control Source or perhaps earlier, in the query
underlying the report.

Regards

Jeff Boyce
Microsoft Office/Access MVP