"The field is too small..." error in form drop-down

[Philip McC]

There are 2 forms using the same select query to create a drop-down.
-The first form is small and wide, and works correctly with-out any issues
or errors.
-The second form is tall and narrow, but gives an error on anything
drop-down selection longer than 50 characters.

a) I reduced the table's text field from 100 down to 72 characters. Where
the longest string has 69 characters.
b) I expanded the list's width and the column width settings past the edge
of the form.

Nothing makes any difference. Is it form level, detail level or other
indirect area affecting that? Any new input is appreciated.

 

[John W. Vinson]

There are 2 forms using the same select query to create a drop-down.
-The first form is small and wide, and works correctly with-out any issues
or errors.
-The second form is tall and narrow, but gives an error on anything
drop-down selection longer than 50 characters.

a) I reduced the table's text field from 100 down to 72 characters. Where
the longest string has 69 characters.
b) I expanded the list's width and the column width settings past the edge
of the form.

Nothing makes any difference. Is it form level, detail level or other
indirect area affecting that? Any new input is appreciated.

What are the RowSource, Control Source and Bound Column properties of the
combo? I suspect you're trying to store a different field than the one that
you think you're storing. The size of the form or of the control on the screen
is totally irrelevant to this issue! You'll get the error if the field
contains a text string longer than 50 characters and the field in the table
into which you're storing it - the COntrol Source - is 50 or fewer.