Unbound Combo Box Does Not Display Values

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I found on the KB information about "Bound Combo Box Does Not Display
Values" but this doesn't apply to me. My problem is that Unbound Combo
Box(es) Don't Display Values. I have not upsized my db.

Any ideas on how I can get my combo boxes to display the value after
selecting it from the list? Access remembers the selection... it just
doesn't show it. Any thoughts are greatly appreciated. Thanks.
 
There are several scenarios where this can happen.

a) If the combo's bound column is zero-width, and you programmatically alter
the RowSource so that the selected value is no longer in the list, the combo
displays blank even though a record is selected. Naturally: there is nothing
it can show.

b) If the combo's bound column is zero-width, and you programmatically alter
the RowSource in the form's Current event, the combo may display as blank
even though the value is in the list. This seems to a timing issue. The
value shows up as soon as you move focus to the combo, Refresh the form, or
Requery the combo; but not if you try these things in the Currrent event.
Adding another control that partially overlaps the combo sometimes avoids
the problem.

c) If you have a form where there are no records to display and no new
record can be added, the Detail section goes completely blank. If the combo
is in the Form Header or Footer section, it will can to display under these
conditions. More info on this bug in:
Incorrect display of data
at:
http://allenbrowne.com/bug-06.html

d) The problem can also be caused by a faulty video driver. You could
demonstrate this to be the case by turning off Hardware Acceleration, or
testing using a plain vanilla VGA driver.
 
Back
Top