Link to home
Start Free TrialLog in
Avatar of agileborders
agileborders

asked on

ComboBox/ValueList Problem

I have a two column combo box, with the first column being a number and the second column being text.  The bound column is column 1, but in my form, I have the column width set to zero for column 1, as I want the text to display.  So far so good - except that when I selected one of the first two choices on my drop down box, it shows up, but any other selections just sort of disappear, although the correct value is written to the table.  Any suggestions?  Here is an example of the RowSource for the combo box/value list:

5.15;"Crucible";5.05;"Crucible Cover";5.70;"Evaporating Dish";2.90;"Beaker - 400 mL";2.50;"Beaker - 250 mL";2.50;"Beaker - 100 mL";2.50;"Beaker - 50 mL";4.65;"Flask - 250 mL";4.45;"Flask - 125 mL";4.10;"Graduate - 10 mL";4.60;"Graduate - 50 mL";5.00;"Thermometer";2.39;"Watch Glass"

Thanks,
Daisy
Avatar of kraig
kraig

I copied that row source and it works for me.  You can try doing it without the quotes, but it shouldn't make any difference.
ASKER CERTIFIED SOLUTION
Avatar of Notapro
Notapro

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of agileborders

ASKER

I'll go ahead and accept this, as I think I meant to post it to the MS Access area anyway - thanks!

Daisy