Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 892
  • Last Modified:

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
0
JustFred
Asked:
JustFred
  • 2
1 Solution
 
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
 
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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now