Best Method to Swap Report Page?

[David H]

Depending on the content of a field, the last page of my
report should contain TEXT1 or TEXT2. This full page of
text must be fully formatted and contains many more than
255 characters. TEXT1 and TEXT2 do not change; the report
merely selects which one to print. What is the best
strategy for accomplishing this?

 

[Allen Browne]

The standard Access text box cannot format part of a field differently from
the rest. Go to:
http://www.lebans.com/richtext.htm
and you will be able to set up and store rich text in a memo field.

Create a table to hold the two alternate entries.
In your main table, you have a field that indicates whether you want entry 1
or entry 2.
In the last section of your report, add a subreport.
The LinkMasterFields/LinkChildFields will tell it whether it's entry 1 or 2.
The subreport will have the rich text control.