The value you entered ins't valid for this field

  • Thread starter Thread starter MWL
  • Start date Start date
M

MWL

Using a unbound combo box I get this error attemping to
update a form. The combo box is a text field that is 64
characters long. I have done this with other text fields
with no problem. Does a unbound combo box have default
lenght limit?

After I click ok on error the field fills correctly but I
get this error every time.

the rest of the error is:
For example you may have entered text in a numeric field
or number that is larger the the Field size setting
permits.

Thanks in advance for your assistance.
 
Check the Format property of the combo.
Make sure it does *not* say something like "General Number" or "Short Date".

For unbound controls, Access validates the entry against the Format it must
use to display the result.
 
Back
Top