Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


ComboBox/ValueList Problem

Posted on 2003-03-03
Medium Priority
Last Modified: 2011-09-20
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"

Question by:agileborders

Expert Comment

ID: 8058526
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.

Accepted Solution

Notapro earned 100 total points
ID: 8059915
Set your column count to one.

Set your control source to the column or field that you want the data stored in.

The value that you want to show in the box put first in the select statment then a comma then add your value you want stored or values

Then set the Bind column to 2.

Author Comment

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


Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question