Report rounding numbers

[missinglinq]

Never had occasion to use decimals in reports before! Why is a number, defined as a Single, rounded when it appears in a report? For instance, number appears as 169.5 in form and table, but appears in report as 170?

Thanks!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[missinglinq]

I found the answer and I've got to say it's one of the weirdest things I've ever known Access to do! The number was being rounded because the text box defined by the report wizard was too small to contain the data! I usually use the wizard to simply throw all the controls I need on the report then rearrange them to suit my purpose. In just futzing around trying to figure this out, I manually took the field from the filed list and placed a 2nd copy of it on the form. This was Access' usual large box and the number appeared, unrounded, as it appears in the form and table. I then enlargened the original text box and it too gave the entire number, unrounded. Very Odd!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!