Letter Customization Architecture

[Zanstemic]

I have a number of letters that were created in report generator and working,
for the most part, well.

I'm looking to add additional functionality to allow for the letters to
change based on specific criteria. For example, having a text box for body
copy in the database that populates if text exists or is removed if the text
box is empty.

At this point I'm looking for the options and recommendations on how to
approach solving this problem. I'm new to access and a experienced novice
with different levels of code. My thought was I may be able to create two
letters and have code that determines which letter to print based on if text
exists.

Also this is only one example and I'm anticipating better approaches exist.

Any suggestions or guidance is appreciated.

 

[Cyberwolf]

My work around was to create a table and based on the text, used one of
several different records. It works very well for me and I just throw the
memo fields in my back end query.

Just my thoughts

 

[Zanstemic]

Sounds good. I'm still new to Access so can identify where you put the
backend query.

Thanks in advance