At Your Survey Question

[Guest]

In tblQuestions, there's a field called RspnsType with this description:
Possible Values 7-Numeric, 10-Text, 8-Date, 1-Logical (data types in Access).

I assume this means that the data type can be chosen for each question, but,
in looking through the design, I don't understand how/where it is applied. I
would like to do this in my own design, because I have two different types of
questions: one is a lookup for which the list will be provided, but the other
one needs to be a memo field (I know this is not ideal, but I can't use a
text field, it must be memo, because of the length of the responses). So, if
I were to use a similar design, how would I add a choice for some of the
questions to be data type=memo? And can you explain how this functionality
works in the current design of AYS? Or, any other suggestions how to do this?
Thank you!

Wendy

 

[Duane Hookom]

I'm not sure I used the RspnsType anywhere. I suppose if you add a memo
field to tblResponses, you could use the on current event of the response
entry form to open a dialog form to enter data into the memo field. I have
also seen where memo values may not be tied to individual questions so they
are kept in a separate, new table.