Format painter in queries

P

Pankaj

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.
 
J

John Spencer

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.
 
Top