Textbox decimal format problem

[emorris1000]

I have some texboxes (read from a datasheet) that have some problems with the decimal format. The field "Density" is shown in a form and a report. In the form I selected the format as "Fixed" and Decimal = 3, and got the number I wanted. In the report I did the same, selected the format as "Fixed" and Decimal = 3, and for some reason it's rounding to 2 decimals. I switched to 4 decimals and it's still 2.

The only difference between the form and the report is that the form is bound and the report is from a query.

I'm pretty sure I can get the correct value by changing the density field in the SQL to "round(table.density, 3) as density", but that smacks of duct tape.

Any ideas?

 

[Alansidman]

What is the format in the underlying table?