Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    best way to store substitute text?

    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

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: best way to store substitute text?

    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.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: best way to store substitute text?

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •