The value you entered ins't valid for this field

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.
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto populate text box based on combo box value 1
cant type more than 11 numbers 2
Pass value to combo box 7
display a value based on a combo box 13
Continuous Form - Populate unbounded field 1
Save values displayed in unbound text fields from combo box to tab 3
Deleting/Changing results in "Value you entered isnt valid for this field" 1
Combo box assigned to a field not working 1

Top