Query Properties not saving

[emorris1000]

I'm sure this is a simple issue, but its driving me up the wall!

I have a query used in a listbox, and I want to format the decimal places slightly differently. I right click the field column, change the format to fixed/decimal places = 0, and then run the query. All decimals are there, and when I go back to redesign the query all the properties are back set to normal.

Same goes for having changed the field headings/captions within the query. It shows up in the design, but goes to the default field headings when I run it.

My guess is that this has something to do with the query inheriting the formats from the underlying table. If so, how do I change this? If not, what's going on?

 

[spikepl]

query used in a listbox

how? Do you have a saved query as record source for the list box, or just an sql statement?

 

[emorris1000]

An SQL statement.

 

[spikepl]

Then there is nowhere to save your settings. Save the query and just refer to the query name in the record-source property

 

[emorris1000]

Ahhhhh ok, since I'm only saving it as SQL there is nowhere to save properties. Gotcha. I'll figure out a way to format it in the SQL, I don't like saving queries for stuff like this unless it is absolutely necessary.