Making horizontal multi-value list box in form

[hayashig]

I am currently using MS Access 2007.

I am not sure if this is even possible but I thought it would be worth asking.
I have made a multivalue field on the form and made it into a list box with check boxs as the possible values, but the list box only lists the possible values down wards. I would like the list to be made horizontally.

Also, my second question is that I would like to record the form values as numbers but want to display it as words (No=0, Yes=1, Maybe=2)

Right now

Are you sick?
[ ] 0
[ ] 1
[ ] 2

Do you eat well?
[ ] 0
[ ] 1
[ ] 2

Trying to achieve

Are you sick? [ ] No [ ] Yes [ ] Maybe
Do you eat well? [ ] No [ ] Yes [ ] Maybe

 

[DCrake]

Even though you have created a MV control on your form you will only be storing 1 value in your field in the table.

Your best method is to create an option group cotnrol on your form that enables you to do what you want. and bind your field to the option group.

 

[hayashig]

Thank you for the reply. The field on the table only needs to store 1 value (0,1, or 2), and as for making the list horizontal, is that possible?

 

[DCrake]

Horizontal, vertical, diagonal, anyway you want it.

 

[hayashig]

When I try to turn it horizontally, I get a weird results.

This is what happens when i set the column count = 2.

[ ] 0 1 2
[ ]
[ ]


Also, I cant change the displayed value the way I have done with combo boxes. I set the column width = 0";2", Row source type = 2, and Row source = 0;"No";1;"Yes";2;"Maybe", but it won't change the 0, 1 and 2 into No, Yes, and Maybe.

 

[DCrake]

You are not doing as instructed. Use an option group type control on your form. see image.

 

[hayashig]

The image depicts exactly what i want to make, but i have no clue about making the option group control. Do you happen to know any tutorial on making this? Thank you for all the help.

 

[gemma-the-husky]

just use the wizard. drop an option group onto your form, and it will take you through the setup.

it will design the buttons vertically, but afterwards, you can move them around to get the placement you want

 

[hayashig]

I got the field to work as I wanted with the values, but it turns out a few of the fields will need multiple value input. Also after I click one of the check box from the option group I cant unclick the field, is there work around for this?

 

[Demetious]

I got the field to work as I wanted with the values, but it turns out a few of the fields will need multiple value input. Also after I click one of the check box from the option group I cant unclick the field, is there work around for this?

I think you are confused at what a "Field" is. A field is what a column would be in Excel, it represents a certain value of a record, which is a row. That being said, your radio button or check box should uncheck itself if you click it again. You said you were using possible mutiple variables. If that is the case, why not create individual check boxes, the user can select what options they want, and then you will store which ones they have checked? I hope that helps. Let me know what you end up doing, I'm interested in learning.

 

[hayashig]

I used the option group to make the field on my form because MV field would not for some reason not become horizontal like so;

Are you sick? [ ] No [ ] Yes [ ] Maybe

Rather it would remain

Are you sick?
[ ] No
[ ] Yes
[ ] Maybe

Also, each box would not be recorded as presented in the form (No=1, Yes=2, Maybe=3) and that would not be possible to my understanding when i used MV field.

But by using the option group, the field would not uncheck when i clicked on it. I would only change values when i click on another choice, but never uncheck when i rechecked the same box.