drop-down error

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

I placed a drop-down list box on a form using the wizard. When I go to form
view showing existing records, then click on the drop-down, I get the below
error. When I click the OK button on the error, the drop-down drops and
works as it should. When I navigate to an empty record the drop-down works
without error. I tried setting the default value to the drop-down to
whatever's in the [AcctName] field. No luck. Both fields are text set at 50
characters. What is causing this?

Error: The value you entered isn't valid for this field. For example, you
may have entered text in a numeric field or a number that is larger than the
FieldSize setting permits.

Query to populate drop-down: SELECT CompanyNames.ID, CompanyNames.AcctName
FROM CompanyNames;
 
What number are you using for your bound column within the properties. When
you use a drop-down box you normally add the primary key for the field and
the field you want to show in the combo box. The column count would be: 2,
the bound column: 1, the column sizes 0;1 (zero hides the primary key). The
list width should match the total of the column sizes. In this case it would
be 1. If you showed the first column and the size was .5, then your list
width would be 1.5".

Your combo box could be mapped to the wrong field.
 
Back
Top