Form letters on Access 2000

  • Thread starter Thread starter Sam
  • Start date Start date
If you are trying to replace tokens in (say) a memo field with the content
of the fields, you could use the Replace() function.

For example, you could replace the text "<<surname>>" in the field MyLetter
with the contents of the Surname field by setting the ControlSource of the
text box to:
=Replace([MyLetter], "<<surname>>", [Surname]"

If you have several tokens to replace, you probably want to call a function
that loops through the various tokens and returns the results to the text
box.
 
What are "textbox tokens". If you mean a text box control, you can reference
the control in the on format event of the section containing the control.
 
After reading Allen's reply, do you mean field tokens in a memo type field.
I just posted an applet demo that you can add to any application that does
this. Users can create their own field list and letters. When editing a
memo/letter body, they press F3 to get a list of fields. When running the
merge, the fields are combined into the memo field and output in a report.
The applet is in the query by form at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
 
Back
Top