Overflow

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I cannot get a report to open in preview mode. It gives
me and "Overflow" dialog box with OK as the only way
out. I can open it in design view. The query it is
based on will open fine.

Any help is appreciated.
 
Phil:

Overflow occurs 99% of the time from one of two issues:

1.) A divide by zero or divide by null problem in either your query or a
control on the report (e.g. = [Control1]/[Control2])

Work around this by using an IIF test for division i.e. IIF([MyField] = 0 or
IsNull([MyField]), 0, [OtherField]/[MyField])

2.) Some statement in your report's code is assigning a value to a variable
that is to large for the variable e.g. assigning a long value to an integer
variable.
 
Steve:

Thank you for your response. I found a divide by zero
problem that when I fixed, the overflow problem went
away. Thanks for your good advice!

Phil
-----Original Message-----
Phil:

Overflow occurs 99% of the time from one of two issues:

1.) A divide by zero or divide by null problem in either your query or a
control on the report (e.g. = [Control1]/[Control2])

Work around this by using an IIF test for division i.e. IIF([MyField] = 0 or
IsNull([MyField]), 0, [OtherField]/[MyField])

2.) Some statement in your report's code is assigning a value to a variable
that is to large for the variable e.g. assigning a long value to an integer
variable.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Phil said:
I cannot get a report to open in preview mode. It gives
me and "Overflow" dialog box with OK as the only way
out. I can open it in design view. The query it is
based on will open fine.

Any help is appreciated.
Click to expand...


.
Click to expand...
 
Back
Top