Combo Box not displaying first value

D

Debbiedo

I am using Access 2003 SP3

I created a Combo Box with two columns. The first column is bound to
the field ID. It is a Yes/No field with a default "Yes". The second
column is displayed on the form.

Here are my property settings that I think may relate to my problem

Name ApprovedCombo
Control Source ID

Row source 1;" APPROVED";0;"NOT APPROVED"
Column Count 2
Column width 0";1.55"
Bound Column 1
Limit to List Yes
Auto Expand Yes
Default Value 1

When I first open up the form, the default value shown in the
ApprovedCombo box is correctly displayed as "APPROVED". If I try to
change this value, it will only display the second value in the list,
"NOT APPROVED". The first value is visible from the drop down menu but
cannot be displayed in the box on form if chosen. It does however, get
stored in the table correctly. The second vaule displays fine.

I made the default value blank both in the property settings and table
design and this did not change anything. I still had the same problem.

Any ideas why this is happening? I am stumped.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top