value entered isn't valid for this field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I built a combo box with only one field that I had created an alias on in a query, but when selecting, the above error message results. The field contains a mix of ID's and Text ...would this be the problem?
 
The bound column of the combo must be the same data type as its
ControlSource.

Open the form in design view.
Right-click the combo, and choose Properties.
On the Data tab, the ControlSource property tells you which field it is
bound to.

In the properties box, which is the Bound Column? (Typically 1 or 2).
The RowSource property tells you where the combo's lookup list comes from.
If the Bound Column was 1, then the 1st column of the RowSource table/query
must be the same data type as the ControlSource field.

To see the data type, open the table in design view.
It is the middle column in table design.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Petra said:
I built a combo box with only one field that I had created an alias on in
Click to expand...
a query, but when selecting, the above error message results. The field
contains a mix of ID's and Text ...would this be the problem?
 
Back
Top