Combo box
I’m running myself ragged trying to figure out why the value in my combo box is not showing a value in the control. However, selecting a value from the combo box will save to the resultant field, it’s just that the value does not “appear” in the form control.

I have two columns in the control.

The bound value is column two.

The control is using a value list.

The column widths are 2 and 0

Column count is 2.

Please advise.

The bound value for the second column should be 1

Thanks for the reminder but the control now tells me I’m entering an incorrect value in control.

Here’s my value list:

System;Yes;Receiver;No

The field saved to is a yes/no data type with yes/no format but the combo box doesn’t show text in the control for current records, it shows a 0 or a –1, when I try & modify the value list to contain these numbers instead of yes and no, I get the same error.

OK.
Try setting the Value List to:
"System";-1;"Receiver";0

Let us know !

Same error.

Ya got me. ;{{

I have it working fine and can't see where your info is different than mine.
My form is based on a table. Is yours?

Sorry I couldn't help any further.

Well mine is updating a query, but the funny thing is the values are storing ok, but the control is just not "showing" anything, even if i use a wizard.

the closest i have got is getting the "receiver" value to appear in the control but not "system".

I'll be honest, this is frustrating http://www.access-programmers.co.uk/ubb/smile.gif

ok, so now I got it working now.

I dunno, it got fixed after I destroyed the control & recreated it again with a wizard. I dunno, but the storm has passed.

The more I work with Access, the more I start feeling that sometimes the bottom line is just getting the damn thing to work !! :}}

What a way to make a living, hunh??

Glad it worked for ya!

Michael

you're telling me! http://www.access-programmers.co.uk/ubb/wink.gif