How do I set the default view for numbers in a Query?

J

JonCarlson153

I am trying to figure out if I can make the default view for numbers to be
1,234,567.89 rather than 1234567.89
 
A

Allen Browne

In query design view, right-click the number field, and choose Properties.

In the Properties box, set the Format property to:
Standard
 
J

JonCarlson153

I can do that, but I'm wondering if it would be possible to make it the
default setting so I wouldn't have to manually change it for every column?
 
A

Allen Browne

There's not a default setting for queries.

If you set the Format of each field in the table, any queries you create
based on that table would probably inherit the format without the need to
specify it in the query.
 
Top