Access Error Code 3163

What can I do to modify my report so that I don't get error 3163?  It says that "the field is too small to axxept the amount of data you attempted to add.  Try inserting or pastin less data."  I already have selected "Can grow" on each field's property box.

Thanks,

Fred
JustFredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dottheiCommented:
The problem is not in your report.
The problem is in a table.
Also CAN GROW refers to formatting, not data.

The error means that you are attempting, by whatever means, to insert data into a field and the data is larger than the field.

My gut says you are summing a field and exceeding the field size.  Maybe involves an update query?

Are you concatenating text?
Are you calculating/adding numbers?

If TEXT, enlarge the size of the Target Field.

If numbers, trickier...
See

Byte Stores numbers from 0 to 255 (no fractions).

Decimal Stores numbers from –10^38–1 through 10^38–1

Integer Stores numbers from –32,768 to 32,767

Long Integer (Default) Stores numbers from –2,147,483,648 to 2,147,483,647 (no fractions).

Single Stores numbers from
–3.402823E38 to –1.401298E–45
for negative values and from
1.401298E–45 to 3.402823E38 for positive values.

Double Stores numbers from
–1.79769313486231E308 to
–4.94065645841247E–324
for negative values and from
4.94065645841247E–324 to
1.79769313486231E308 for positive values.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JustFredAuthor Commented:
I tried looking at the tables to see if there were anyfields that needed to be looked at as you told me.   I changed a few and tried running the report again.  It didn't work.  I am going to check the query  and see if I messed up something in it.  It gives me the same error even though I can put all of the data I want in the field.

Thanks.
0
JustFredAuthor Commented:
Sorry for the delay.  I did have to tweak the tables a little in order for the reports to preview as they should.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.