What I have is a databse of questions and for every questions, there is a
quite lengthy description of the different ways one answer the question and
how to answer the question. I am struggling to find out what is the best way
to design a form so that the users can answer each question, and if they want
more detail on how to answer the question, they can see it somewhere on the
form or click a link or something that display the whole description for that
particular question.
I tried using label for the descriptions but I ran out of space on the form
to fit everything in. Is there another effective way? Thank you.
In another thread it appears that you're storing the question itself in the
fieldname, and now you're trying to store yet more information in the field's
Description?
You're missing the point I fear! You should store information *IN YOUR TABLE*,
in Text or Memo fields in the table - not in the table's structure.
Consider a structure like
Questions
QuestionNo <Primary Key>
Question <Text>
QuestionDescription <Memo>
You could have ten, or a hundred, or a thousand questions, each with 255 bytes
for the question text, and 65536 for the description of the question; you
could display the question and the description on a Form (single form if you
want to see one question at a time, or Continuous if you want to see multiple
questions on screen). The user's answers should be stored in a different
table:
Answers
AnswerID <autonumber primary key>
UserID <link to a table of Users, who is answering>
QuestionNo <link to Questions, which question they're answering>
Answer <whatever datatype is appropriate>
Repeating: Look at At Your Survey. It addresses the questions you're
struggling with, is a good teaching tool, and can often be used "out of the
box" to record questionnaire type data.
