Form Layout

[Del_Piero_3]

Hi,

I am not sure how to design my response form for a survey questionnaire database.

At the moment I have "ResponseText" and "CommentText" fields that are used to store answers. The problem is each questions have different type of answers:

select one from the list or the user types the answer etc

I was thinking whether it is possible to change the state of fields (memo field where user enters answer, field that changes to yes or no etc) in the form according to each questions. Can someone guide me to right direction and I'll take it from there. I hope I make sense. Thanx

 

[Treason]

You probaly didnt mean to say this but let me quote you...

it is possible to change the state of fields

Yea this is possible but it is bad database practice. Designing your database is the most important step and should be taken before anything else. Consider all the fields you may need and all data type that will be appropriate for those fields. If you switch data types after you enter data you will run the risk of data loss. Try it out, create a text field then change it to date/time... etc.

I didnt mean to lecture or anything but it's a generally bad idea.

Why not keep your answer field as memo and store the Yes/No value in it?

 

[Del_Piero_3]

First of all thanks for the reply. I am new to MS access so my knowledge isnt that good.

Why not keep your answer field as memo and store the Yes/No value in it?

I know what u mean here, but not every question has the value of yes/no, some do but some have a different values to selct from i.e. select a number between 1-10 OR select small, medium, large OR theres no selection and the user is required to enter the answer manually. Thanx

 

[DrSnuggles]

Try this???

Why don't you have another field that you use as an id key.
This id key could be:
1 (For Text)
2 (For Numeric Values)
3 (For Boolean)

Then on your form create 3 different controls to handle each one.
i.e. Tex Box, list box, combo box . . . .

Dependent therefore on your question (and thus id key) you can hide/display the relevant control.

Use Dlookup to find the id key, then use Select case to make visible the control.

I'm not sure if this helps?!

Good luck!

 

[Del_Piero_3]

Why don't you have another field that you use as an id key.
This id key could be:
1 (For Text)
2 (For Numeric Values)
3 (For Boolean)

Then on your form create 3 different controls to handle each one.
i.e. Tex Box, list box, combo box . . . .

Dependent therefore on your question (and thus id key) you can hide/display the relevant control.

Use Dlookup to find the id key, then use Select case to make visible the control.

I'm not sure if this helps?!

Good luck!

Thanx, I think I know what you mean, will try it out.