Text box and Overflow

[gmit]

Hello
I have a text box on a report that calculates a total, control source is
=Sum([NetWgt]*([nett]/[paywgt])).
This works fine but sometime when I run the report I get the error Overflow.
I no this error is caused when a variable isn't large enough ie an integer is used instead of a double but what causes this in a text box?

 

[KenHigg]

Maybe you need to round this: [nett]/[paywgt], to a couple dec places...

Edit: =Sum([NetWgt]*(round([nett]/[paywgt],2)))

???

 

[gmit]

Access 97 didn't understand the round function but I did alter the decimal place and changed to currency and that solved the problem thanks