Combo Box Visability Issue

  • Thread starter Thread starter Matthew Martin
  • Start date Start date
M

Matthew Martin

I have a question, I am successfully pulling data from my combo box, but it the form, some of the fields are updated, but you cannot see the value. I can copy (the field has the correct value, but all you can do is highlight, not see it) and paste it somewhere else and it is visible. Can someone help me with this?

Thanks
 
I have a question, I am successfully pulling data from my combo box, but it the form, some of the fields are updated, but you cannot see the value. I can copy (the field has the correct value, but all you can do is highlight, not see it) and paste it somewhere else and it is visible. Can someone help me with this?

Thanks
Click to expand...

Hard to tell with this little information, but:

1) In Access 2003 SP3, there was a bug that caused combobox values to
disappear. Hotfix http://support.microsoft.com/kb/945674 resolves it.
You actually should apply this Hotfix anyway if you are running Access
2003 SP3 - it resolves several Access problems that were introduced
with SP3.

2) In Access 2003 and older, there is a bug where the value in a
combobox is invisible when the combobox is unbound and in the heading
of a continuous form and there are zero records in the recordset. If
this sounds obscure, it really isn't - imagine that you have an
unbound combobox as part of the selection criteria. You pick some
criteria that results in zero records. Your combobox goes blank.

The workaround is to requery the combobox (not the whole form) after
the criteria is applied: Me.[mycomboboxname].Requery

This bug was resolved in Access 2007.


Hope this helps,

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top