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.
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.