At Your Survey Question

G

Guest

Hi

I have been going through the At Your Survey template (thank you Duane) and
have a question. I would like my 'RspnsType' to be various things, some text,
some yes/no some date etc.

I'm not sure how to use the RspnsType associated with each question to
control the Data Type of the Answer on a form.

I hope my question is clear - thank you for your assistance.

Tarryn
 
D

Duane Hookom

The actual answers are all stored as text. I suppose you could use the
RspnsType in the on current event as a user is entering responses to check
for IsDate() or IsNumeric() or other to match the desired data type. There
is a little code that could be modified in the On Current event of
sfrmResponses.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about how a field in a table is used 2
At Your Survey Question 3
At Your Survey Question 1
Using "At Your Survey" for storing and comparing survey results ofeach year 1
Question and Answer tables 3
"At Your Survey" Design Question 1
Survey Database Table Form Design 5
HLP! Y/N with other Input Options 4

Top