News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • best way to store substitute text?

    Posted on WSsanora Comment on the AskWoody Lounge

    Home Forums AskWoody support Productivity software by function MS Access and database help best way to store substitute text?

    Viewing 1 reply thread
    • Author
      Posts
      • #351899 Reply
        WSsanora
        AskWoody Lounger

        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

      • #510484 Reply
        WSBrian Swann
        AskWoody Lounger

        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 = IIf([Q1],”Mary had a little lamb”,”Baa baa, black sheep”) This assumes the answer to Q1 is captured in a Yes/No field on an input form and stored in a results table.

        • #510491 Reply
          WSsanora
          AskWoody Lounger

          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

    Viewing 1 reply thread

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: best way to store substitute text?

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.