Default Number Format in Queries

[Ken Sadeckas]

Does anyone know if it is possible to set the number
format for query fields to standard?

 

[[MVP] S. Clark]

In design view, open the properties windows, click on desired field. Locate
Format Property. Set to Standard.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Ken Sadeckas]

I understand that, but I want to set the default for all
fields whenever I create a query to be Standard format.
Can it be done? Sorry if I was not clear.

 

[[MVP] S. Clark]

If you set the property in the table, then it will carry over to the
queries, forms, and reports. Meaning that AFTER the property is set in the
table, AND THEN a new query is created, it will carry over. It won't modify
existing.