Access Form with memo message

[Guest]

I want to merge some fields from a database with a memo field that is on the
same form. The memo field has a message that I want a telemarketer to read
and as you navigate through the records the name of the contact and centain
other fields should change. It sort of like doing a mail merge letter but
done on a form that udates the message as you move from record to record.

 

[Daveo]

Hi Moche,

How about something like this. Assuming you have something like the
following fields already:

txtName
txtDateJoined

You could put the following in the control source of the memo field:

="Dear "&[txtName]&". Blah blah blah. I notice you have been a customer
since "&[txtDateJoined]&". Blah Blah blah"

And so on....

Hope this helps - David

 

[Guest]

In the control source of the field that merge the data from different fields
in the form you can write

=[Field1Name] & " " & [Field2Name] & " " & [Field3Name]

I hope that what you mean