Numbers look right on the form, report shows #####

[Mimadocken]

I've just spent a couple days getting a form to display the numbers on a subform with the correct number of decimal places. WHEW!!

However, I'm trying to print a report from that form and subform. Of course, we're back to the same problem. I need to see a report AND a subreport that display the same calculations, and I seem to be right back where I started. On my subreport, the numbers that appeared on the form are back to displaying ####### instead of a few digits with two decimal places.

Any clues on how to solve this? Thanks in advance.

 

[Aronvitki]

You also may want to use the Round function as well. You have to specify how many decimal places you want.

Syntax: Round(number, # of decimal places)

 

[Mimadocken]

Widening the textboxes did the trick. They are showing 2 decimals and looking good. Thanks everyone!