Change format property of a field in a query.

[Guest]

I was wondering if anyone would assist me. I have a query (qryCalcs), and I
was wondering if I could change the Format and DecimalPlaces properties of a
field in the query.

Let me clarify so that you don't think I'm going off the deep end. I am not
trying to change the properies programmatically just for one field. I have
about 75 fields that I need to change all to Percent format with 1
DecimalPlace. For this problem, I can hard code the field names for doing the
change b/c this would a one time update, but I can see where knowing how to
access the properties of a query can be very helpful when having to change a
large number of fields to the same property sets.

Thank you,
Ken

 

[Guest]

You can do it in the query but remember the format is only changing the
display. If you then use the query for a form or report it will not be
formated. You have to format in the form or report.

To format for the query display open the query in design view and move the
cursor vertically from top to bottom of the column until a down arrow is
displayed for the cursor. Click to highlight the column. Them right click
and select properties. Type in Standard and then set the number of decimals.