The Value you've entered isn't valid for this field Error

[hyedipin]

I am not sure why it is coming up now.
I set up a combo box with Auto Expand property set to yes, but now whenever I hover you mouse over it, I get this error.

The field has been set as Text with 255 max char limit, and non of my rows have over 100 characters in that field.

Why is this happening?
Thanks.

EDIT: I just deleted that combo box and created a new one with "find a record" instead of "lookup" and it seems to work.

 

[JonathanAnon]

You seem to have this sorted anyway but,
There may be an underlying problem with the field that is the control source for the combo. You should check the table that the field is associated with and see what parameters have been set on it. The issue is usually something to do with this in my experience.

 

[hyedipin]

Thanks Jonathan,

After doing this, I found another problem, sometimes that combo box info will not match the other information in the form. What happened was I typed something to the box, it didn't find, so I hit enter and went to next item. I realized that although the combo box went to the next "customer" the Memo or Notes field i had for this customer didn't change, and for some reason got copied into the next customer. As I scrolled up and down, some of the information were duplicated into the other customers.

 

[JonathanAnon]

sometimes that combo box info will not match the other information in the form.

I'm a bit confused as to what you are trying to do.

1. Where does the combo box pull it's list from? Why should it match the other information in the form.
2. What you were saying about adding the information to other records. Are you saying that the form is cycling through the records? I normally DONT allow any form to cycle through the records. I have it cycle through the current record only, so that if you tab off the last tab-stop control it will not move on to a new record but will bring you back to the the first tab-stop control.

 

[hyedipin]

I wish I could post a video.
I already deleted the mdb and all projects because I thought I messed it up.

I used the Contact Management template and just modified it.
I changed the source data table from the default one to the one I imported.
I created a Combo Box, and I told it to Find a Record in the "CustomerName" field.

I told it to Auto Expand so that I could type in the combo field and it would auto-complete.

But sometimes I would type something which is not found in the list, then I scroll down on the mouse, which goes to the next record. At this point, I noticed that the "Notes" I had for the latest record were somehow copied over to the next record in the "Customers" drop down. I agree this is difficult to understand. I am not that familiar with Access but this is what happened. Next, I noticed that this time "Customer" was copied over to another Customer, now I have two "ABC Company" with different phone number, etc.. then I realized there are two ABC company, one with correct phone, address, etc. Other with ACME's details.

I thought there was a problem with linking dropdown info to the other details in the form.

Maybe I should not use the template, instead do my own form?

 

[JonathanAnon]

Sounds like you're making it difficult for yourself.

At this point, and not being familiar with Access (as you say), I would think that you are probably scrapping it and starting with the Contact Management template again.

Why dont you make your data fit the table that exists already instead of trying to create your own table. At least if you import your info into an existing table you can be sure that all of the existing controls will work fine.

Only then can you really think about adding your own.

 

[hyedipin]

I agree. That's why I asked in another topic if there was a way to tell Access which Columns in my Excel sheet should go to which fields in Access. I got no response. Do you know how to do this?

http://www.access-programmers.co.uk/forums/showthread.php?t=137412