Yes/No Combo Box Displays -1 and 0 instead of Yes & No

[gtroiano]

I have a data entry form and on this form there is a combo box for Yes or No. The problem is that when the combo box get the focus it displays -1 instead of Yes and 0 instead of No. Is there any way that it will only display the words "Yes" or "No"? thanks!

post script: the combo box is based on a table.

Jerry.

 

[WildHare]

I wouldn't advise using a combo box - use an OPTION group instead, with TOGGLE BUTTONS marked YES and NO, and bind the O/G to your yes/no field. Make sure in the O/G setup process you alter the default values to -1 for YES and 0 for NO.

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[gtroiano]

thanks for the suggestion. if all else fails i will probably wind up doing just that. does anyone know of a way to keep the comobo box but not display the -1 and 0?

jerry.

 

[mikehoot]

Go to the Properties of your combo, and change Format to Yes/No.

:-9

 

[gtroiano]

it is already. the data entry part works fine. the only hangupis when you select the combo box a -1 or 0 appears instead of yes and no. if you click on the pulldown arrow it even displays Yes, No. any other suggestions?

jerry.

 

[WildHare]

In the table, a YES/NO field stores a -1 or a Zero. It's only the DISPLAY Format of that guy that you change change to YES/NO, TRUE/FALSE, etc.

Since your combo box appears BOUND to the field, it will display the value in that field.

The only other way to do it would be to base the combo on a table that has two fields - a text field with YES or NO in it, and a number field that has -1 or 0 in it. Two records will be needed. Use this table as your combo source (unbinding it from the real table YES/NO field) and then updating the real table's YES/NO field via the combo box - it's an extra step, but it should allow you to display YES or NO in the C/B.

HTH

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[gtroiano]

jim,

thanks a bunch. it worked like a charm!

jerry.

 

[MyMainManMoe]

use queries instead of tables for your data source "combo box and also for your forms, store combo box information in the appropriate field which it should write back to the table YES/NO