Format numbers for a calculated field in a query?

[Access_Novice]

In design view if I right click a column and select properties, I can specify a number format under the format property. I can do this for a column with numbers.



But in the case of a calculated field, I can't do this. In the format property box, the drop down menu doesn't have any choices listed. Why? How can I format the numbers in my query results for a calculated field?

[June7]

I never set format properties in tables and queries, only in textboxes on forms and reports.

I will use Format() function in queries. However, this results in a string value and can cause unexpected results if the field constructed with Format() expression is used in other calcs.

[Bob Fitz]

Perhaps by using the Format() function. For syntax see: http://www.techonthenet.com/access/f...ric/format.php