Access Error Code 3163

Posted on 2003-03-19
Medium Priority
Last Modified: 2007-12-19
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.


Question by:JustFred
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

dotthei earned 200 total points
ID: 8171458
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...

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
for negative values and from
4.94065645841247E–324 to
1.79769313486231E308 for positive values.

Author Comment

ID: 8174200
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.


Author Comment

ID: 8232811
Sorry for the delay.  I did have to tweak the tables a little in order for the reports to preview as they should.

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question