Conditional Display of Text Box/Label in Report 1

[huv123]

I have a database that is used by participants in my study to fill out questionnaires. I am in the midst of producing reports for each of the questionnaire. So far I have created it so that a dialog box pop-up when I click on the button to the open the report for Questionnaire 1 allowing me to filter it just for that participant.

The report is essentially a reproduction of a paper based questionnaire which will allow me to see which answers the participants chose to particular questions.

Right now I have the number of the choice displayed i.e. next to question 1 for example if they chose the first answer then a 1 is displayed and so on,

I would like it if rathen than the number of the answer chosen was displayed, if i oculd display the actual statement.


Is it possible to conditionally display a label or text box based on a else if statement i.e.

If quuestion 1=1 then one line of text is visible, if question 1=2 then another line of text is visible and so on...?

 

[Remou]

I think that you may find a combobox useful. An If statement can get unwieldy when there are many options.

 

[huv123]

There are only 3 options.] for each question. I really want the "access" element to be invisible and just look like text on a page when printed.

 

[Remou]

3 options.] for each question."

Are they the same three options? If not, IIf or Choose would not be suitable.

The fact that you have used a combobox would not be apparent another option would be to modify your query.

 

[huv123]

THey are not the same thing for each question but basically
in the form it looks like:

Question One: Is your residence a:

a. House
b. Flat <-- Lets say I selected this
c. Town House


Question Two: DO you wear:

a. High heels <-- Lets say I selected this
b. Sneakers
c. Loafers

THe answers are presented as an option group.


Therefore when the report opens, right now it looks like


Question 1: 1
Question 2: 2


.. and so on...

What I want it to make it look like is:


Question 1. I wear (this text is displayed in a label): _________

the blank space is filled in with different text depends on what I chose in the form

 

[Remou]

I suggest you use a query to join the answer table to the question table on question and answer numbers and base your report on the query.