Error message

[2Grandpa]

I have been developing a database since January. Making changes while poeple are recording data. Last week we starting getting this error message when a form is opened or when I try to run the query by it's self:
"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."

There are 41 items in the query and three tables are linked. I have tried changing the joins on the tables but this did not help. No major changes were made before for about three weeks before this happened. This is an inspection database. The last major move the characteristics to a seperate table so additional charactericics could be added. I did not develop this database but was assigned to change it for our use.

Any ideas? Thanks

 

[ssatech]

Have a look at thread702-1048979

 

[Myvee]

Hello - I'm definitely no expert with this stuff but have you tried opening your tables up in design view and looking at the field size allowed? I'm assuming you are talking about text fields. I think I had a similar problem like this before and it was because field size was set too small to allow the data being entered.
Hope that helps.

 

[2Grandpa]

How do I find thread 702-1048979?

 

[PHV]

thread702-1048979

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[2Grandpa]

PH,
Thanks for reminding me of the rules.

It turned out that the table was bad. I replaced it and now it is working again.

T