Format a number within a text box.

[hefly]

How do I format a number in a text box on a report?

I have the following expression in a text box on my report:

="as listed in the " & [County] & " County, " & [State] & " totaling " & [LEGALACRES] & " acres, more or less."

I have formatted LegalAcres as three decimal places in both my table and in the query that the report is based upon. Yet, the report carries the number represented by the field [LegalAcres] out to 12 decimal places.

How do I format that field to "standard" number type and 3 decimal places?

Thank you.

Hefly

 

[hefly]

I got it!

="as listed in the " & [County] & " County, " & [State] & " totaling "& Format([LegalAcres], "#,##0.00")" acres, more or less."

Thanks!

Hefly