Combo Box to show images

[weircolin]

Hi There

I am wondering if someone can help me. I am using access to create a
survey/questionnaire that children with disabilities will be using. I
am trying to make it user friendly for them and I am at the beginning
and already hit a snag.

I am using Access 2007 although I can use 2002 if it will make it
easier (used to using that, trying to get to grips with new layout in
2007 still).

There are several questions, some of them are straighforward and will
just have space for them to type and answer. The ones I am trying to
do at the moment says something like...

What do you like doing when staying here?

Then there are various different ones like playing outside, swimming
etc. The guy who is wanting this done had done one on paper, but a
lot of the young people respond much better when using a computer.
For each of the choices they have there are smiley faces next to them
(wingdings J K and L) and he is looking for them to be circled. Then
there is a space for comments.

I am wondering which is the best way to do it and if either of them
are possible, and if they are, how would I go about doing them?

1. Having a Combo Box that would display the smiley faces that they
can choose from

Or

2. With each comment there are three buttons next to them each with a
smiley face on them, if so, how would I save this to the table?

Thanks

Colin

 

[Ivan Grozney]

Colin,

I have done something similar to your idea 2. I just create and option
group on the form using the toggle button option. Then create a label that
is the same size and shape as your toggle button with your color or whatever
on it. Then after you get the option group working how you want, move the
toggle overlay on top.

I have used colors and not pictures but I think it would work.

HTH

Vanya

 

[weircolin]

Thanks for your reply, makes sense. Would that mean however that for
every question I would need to have three fields in a table?

Cheers

 

[Ivan Grozney]

Colin,

I was on holiday so sorry for the late response.

The option group data gets stored in one field. Say you have a
question relating to swimming.
Does Swimming Make You:
Happy option value = 1
Okay option value = 2
Sad option value = 3

Then in your table there is one field called Swimming.
if swimming = 1 then they are happy
if swimming = 2 then they are okay and so on.

HTH

Vanya