"Overflow" error message in Access 2003 report.

[care]

I'm trying to switch from the design view to a print view of a report and an
error message pops up saying "Overflow". I have no idea what this means or
how to fix it.

 

[Clifford Bass]

Hi,

Overflow means that some calculation is creating a value too large to
store in something. Is your report's Record Source a query? If so, does the
query work? If not, the problem is in your query; probably a calulated
field. If the query works, do you use calculations in your report? If so,
one of them may be a problem. Try removing them temporarily one at a time
until it works. Then you will know the source of the problem. It may be a
good idea to do this with a copy of the report so you can revert back to the
original once you locate the problem. If none of that helps, does your
report have VBA coding associated with it? If so, check for calculations or
assignments where some value may be too large to fit into some variable.

Hope that helps,

Clifford Bass

 

[Clifford Bass]

Hi,

Overflow means that some calculation is creating a value too large to
store in something. Is your report's Record Source a query? If so, does the
query work? If not, the problem is in your query; probably a calulated
field. If the query works, do you use calculations in your report? If so,
one of them may be a problem. Try removing them temporarily one at a time
until it works. Then you will know the source of the problem. It may be a
good idea to do this with a copy of the report so you can revert back to the
original once you locate the problem. If none of that helps, does your
report have VBA coding associated with it? If so, check for calculations or
assignments where some value may be too large to fit into some variable.

Hope that helps,

Clifford Bass