Hello,

I'm trying to create a yes/no option or tick box on a form. My source table field is already selected as a yes/no type but I can only get one tick or option box displayed on my form.

I know it sounds silly...but this is really getting to me!!

Help

why do you need more than one?
if the answer is yes/no...it's either one or the other..please give more detail

Sometimes the developer wants to display both a yes and no box simply for the users' visual benefit. The concept of on/off may be a bit abstract to them.

There are a couple ways. The one I use is to create an option group and display that. I have the value stored in the appropriate data element.

Use the wizard for option groups. Assign the choices of yes and no. Choose option buttons or checkboxes. Assign the value of -1 to the yes and 0 to the no. Tell the wizard to store the value in the appropriate field of the form's undlying record source. You can even choose a default value this way.

To make a quick method of reproducing these option boxes. Copy and paste them where you need them on your form and change the datasource to the field they need to control.

The other way is simply putting an unbound checkbox next to the yes/no checkbox that IS bound.

Hope this helps.

Thanks for your help jwindon, thats exactly what I needed.

Maz