Decimals being rounded

[nezza]

Hi,
I've got a text box on a report that displays a number of fields from a data entry page, two of which are number fields. I want the number fields to have comma sperations and decimal places and so have set the format as 'Standard'.

My problem is that if I flag one field as standard then it will display decimals correctly, but when I add the standard tag to the next number field it will cause both fields to round decimals to two decimal places.

How can I stop the the field from being rounded to two places?

=[Currency] & " " & Format([Amount],"Standard") & " " & Format([Units],"Standard") & " " & [Text]

Thanks in advance

 

[GaryPanic]

without looking too deeply

Currency
might be your problem
if this is formated to currency standard then it will round up/down etc according to currency forat rules - g