Query results don't retain Currency format

[SunGodly]

I have a form that is based on values from a query, including cboPromoName (combo to select promotion) and curPromoDiscount (set to column(1) of above selection). The form field for curPromoDiscount is formatted as currency, as are the query field and the table field the query is based on. However, the results don't show up in the currency format! Any help would be greatly appreciated.

 

[shannonp]

Hmmmmm, strange, what you have described should have worked? Anyhow, another alternative is to set the source of your curPromoDiscount form field to:

=Format([curPromoDiscount],"Currency&quot

If the above statement produces an error then [curPromoDiscount] isnt actually a number in the first place. (Check and see if any of your data contains spaces in between numbers or miscellaneous letters rather than numbers.

If you do have 'bad' numbers then you could use the following rather than the latter code:

=IIf(IsNumeric([curPromoDiscount]),Format([curPromoDiscount],"Currency&quot,[curPromoDiscount] & "Is Not A Valid Number!&quot

Good Luck