Format painter in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I have to set number format in many query fields, I have to select each
field in the query grid and set the individual properties to, say, "fixed
with 2 decimal places".
Is there some way to copy the format from one field to the others or set
format of a number of fields in one go?
Thanks.
 
Not in a query. Other than Copy and paste (one field at a time)

You can do this with the controls in a report or a form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting date gives bad results in query 2
Number Format not working 2
Currency Format Lost in Union Query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Number format resulting from an aggregate query 7
Formatting sums in crosstab? 7
Multiplication in Query and Precision 1
How do I get Access to append the exact amount with decimals? 2

Back
Top