best way to store substitute text?

[sanora]

Task - a simple survey. The report needs to substitute text for answers. Thus if Q1 is yes, report entry "Mary had a little lamb" but if no "Baa baa, black sheep". Where should text answers be stored?
Thanks

[Brian Swann]

If I read you post properly, could you not simply store them in unbound text boxes on the report itself ? e.g. in the control source of TextQ1 <font color=red>= IIf([Q1],"Mary had a little lamb","Baa baa, black sheep")</font color=red> This assumes the answer to Q1 is captured in a Yes/No field on an input form and stored in a results table.

[sanora]

Yes, I could. However, the survey is VERY long, and it would be far simpler to have data in an table or some easy-to-access object instead of scattered throughout individual combo boxes or text box formulas. Sorry I was so cryptic.

And thanks again