How do I change the value assigned to yes and no?

[etislost]

I have a combo box set up to record yes/no responses. Yes is currently recording as 0 and no is currently recording as -1. I would like to switch no to 0 and yes to 1. Is this possible? If so, how do you do it?

Struggling with my lack of knowledge,
Steve P.

 

[formerTexan]

Hi,

Why not use an option group with yes/no?

Cheers,
Bill

 

[etislost]

Whether it is a combobox or an option group doesn't matter. Both fulfill the same requirement. I am interested in the value stored in the form. How do you change the numeric value recorded for a yes response to 1 and for a no response to 0?

 

[PHV]

Change the Field type from Boolean to Byte ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886