Mail Merge Report Style

Angel-888

Registered User.
Local time
Tomorrow, 05:06
Joined
May 13, 2013
Messages
12
Hi, I am building a report in Access 2007, similar to a mail merge word doc where I have a text then want to add a field in the middle of it, such as:

This Service Agreement has been negotiated by [CompanyName] to enable provision of a [ServiceType] service.

I have added "&" with the field names also "=" at the beginning all with no luck, when in print preview or layout view I see the text as it is shown above with the names of the fields in the brackets.

Can someone please help. Thanks
 
It would help to see your effort, as you're using the correct tools. Did you put the literal text in quotes and the fields outside?
 
Thanks for helping,

The exact format I am entering is:

"This Service Agreement has been negotiated by "&[CompanyName]&" to enable provision of a "&[ServiceType]&" service."

Yet the response when I go to print is:

This Service Agreement has been negotiated by [CompanyName] to enable provision of a [ServiceType] service.

I'm going nuts as I don't want to add the data in a table format it needs to read like a letter.

Thanks
 
Did you have the equals sign? I'd add spaces around the ampersands. I do this all the time; it should work. If you're still stuck, can you post the db here?
 
Hi Paul,

I've attached a simple version of the database I am creating with just the Rental Agreement Report. As you will see in the first two paragraphs I have some fields I want to merge. Perhaps I have the spacings all wrong?

The Access database version states "Access 2007-2010" so not sure if that has anything to do with it.

Thanks again.
 

Attachments

You have that as the caption of a label; it needs to be the control source of a text box. Also watch out for the double quotes within the string. ;)
 
Great thanks I forgot about the control source. All is working as it should, I've changed the text a little so I don't have the double quotes in the string.

Thanks again :)
 
No problem; you can have the quotes, it just takes a little effort. Welcome to the site by the way!
 

Users who are viewing this thread

Back
Top Bottom