Apply formatting to query results

[Access_Novice]

I have some calculated fields that I would like to format when they come up in my query results. How do I format the values in the query result?

[pbaldy]

You can't in a query, easy in a form or report (Conditional Formatting on the ribbon). I only let users interact with forms and reports.

[Access_Novice]

Since my last post I have found out that this is possible. In query design, right click the field and select properties. Then under the format field, click the empty box and select a format from the drop down menu.

[June7]

Paul, were you thinking the OP wanted dynamic formatting?

I've never used format property in query. Does the formatting carry into a report? Let us know if you find out.

[pbaldy]

I assumed you meant colors or dynamic formatting. I still wouldn't let a user see a query.

[June7]

Agreed. Users should not interact with tables and queries - only forms and reports.