I am using Access 2010.
I have one table question bank and a few queries that pull random question by category for the bank. I have created reports based on these queries. The output is simply something like
1. Question contents
a. Answer one
b. Answer two
c. Answer three
d. Answer four
It just repeats the required number of questions per the query. What I would like to do is see if there is a way to hide when a text box has no value? For example
1. Question contents
A. True
B. False
C.
D.
I would want to remove text box c and d and allow the report to shrink down and save a little space. Is this possible to achieve or a bridge too far?
I have one table question bank and a few queries that pull random question by category for the bank. I have created reports based on these queries. The output is simply something like
1. Question contents
a. Answer one
b. Answer two
c. Answer three
d. Answer four
It just repeats the required number of questions per the query. What I would like to do is see if there is a way to hide when a text box has no value? For example
1. Question contents
A. True
B. False
C.
D.
I would want to remove text box c and d and allow the report to shrink down and save a little space. Is this possible to achieve or a bridge too far?