Replace data in memo field

[Diederik Nieuwenhuis]

hello all,

Hopefully someone can help me. I want to create a report
(based on a query) where I want to replace data within a
memo field. Below an example:

Memo field : fill in name @01 and look for street @02.

The @01 and @02 represent a reference to variables. For
example, the @01 means "jansen" and @02 means "first
street".

How can I create soemthing which replaces the @01 and @02
with the actual data so I can create a report with the
outcome: fill in name Jansen and look for street First
Street.

Thanks,
Diederik

 

[Allen Browne]

In Access 2000 or later, you could use the Replace() function to replace the
place-holder-charcter with the actual data from the record.

You would need to run the replace multiple times - one for each of your
place-holders.