Overflow

[cgshunter]

I am receiving an error when trying to preview a report. It states "Overflow" with no help option to figure out what's going on. I've been running the report all day until now. The error pops up even though I have made no changes to the report. HELP!

 

[doss]

I don't know the answer, but I did a search on this forum for overflow and came up with a lot of threads. You will probably be able to find some help that way.....

 

[J.Windebank]

I believe Overflow is where you are trying to place too much text in a variable.

Such as trying to put 10 digits in an int would give this error. This happened to me a few times last night, and changing from int to long fixed it, so it may be your problem?

Hope this helps a little.

 

[J.Windebank]

Just found this description in the Access 97 help files:

Overflow (Error 6)

An overflow results when you try to make an assignment that exceeds the limitations of the target of the assignment. This error has the following causes and solutions:

• The result of an assignment, calculation, or data type conversion is too large to be represented within the range of values allowed for that type of variable.
  
  Assign the value to a variable of a type that can hold a larger range of values.
  
• An assignment to a property exceeds the maximum value the property can accept.
  
  Make sure your assignment fits the range for the property to which it is made.

For additional information, select the item in question and press F1.