Error 3163 with combo box

[MNtoAZ]

I have Access 2000, and am getting the following error message:

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. (Error 3163) The field into which you tried to insert or paste data is not large enough to hold the data. Try inserting or pasting less data.

The issue is that I have 6 choices that I would like to be able to choose from and the longest choice has 14 characters. (the text box is more than large enough for everything to fit so I am confused as to why it is telling me the field is not large enough).

I have looked in my Access plain & simple book, Access for dummies and The complete Reference for Access 2000 and I cannot find an answer! I have also searched the forum and found similar errors in threads, but none of them address this issue in a form with a combo box.

I am not proficient in code and not a computer genius, so if you could please explain to me what is going on in plain English I'd greatly appreciate it!


Thanks in advance!

 

[boblarson]

What size is the field (in the table, not the text box). How many characters have you set to be available at the table level?

 

[MNtoAZ]

I have no idea as someone previous to me set this up and I was trying to change it...where would I find how many characters are available at the table level?

 

[boblarson]

 

[MNtoAZ]

It says "Long Integer"

 

[boblarson]

Hmm, not sure then (it probably is set to take the ID number of the item and not the text then). Any chance you can post your database?
http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[MNtoAZ]

I'm not able to post the database as it has sensitive personal information... Would it be best to just start over from scratch with that table?

 

[boblarson]

Can you make a copy of the database and then remove all personal information from the tables?

 

[MNtoAZ]

I have 984 entries....

 

[boblarson]

I have 984 entries....

just delete all of the data then (open the table in datasheet view, click EDIT > SELECT ALL RECORDS and then EDIT > DELETE RECORD (or hit your delete key) and it will get rid of them all.

 

[MNtoAZ]

Ok... Sorry I had to take a break. So do you just need the one table or ALL of the ones that I use?

 

[boblarson]

Ok... Sorry I had to take a break. So do you just need the one table or ALL of the ones that I use?

Need the form you are having problems with and any tables and queries that support that. It would need to include the tables/queries that are also in the combo box's row source.

 

[MNtoAZ]

Hey thanks for your help, I was able to change the type from list to combo box and then it let me enter the number of characters!

 

[boblarson]

Cool, glad you got it worked out (and good you did it yourself too as that is even better on the learning curve )