I am attempting to design a database for surveys. Some user will create a survey with however many questions they want. Then other users will answer thos questions. What I would like to do is to take advantage of the ability of report fields to grow, and have the questions be in a report, with a subform for each question to allow the user to enter the answer. I could easily do this in a form, but form fields do not grow/shrink with the text contained therein. I would like the user to be able to just scroll down and read all the questions in one long form, and have a spot on each question to fill in the answer.
Thoughts/suggestions?