formatting..

[apoll0]

Ok, don't know what I should title this problem as, but maybe you guys can help. The data stored on my table is formatted as Currency, however, when I Queue up the data, I also multiply it by a factor (exchange rate). Which turns the data into just a regular number. When I display this data on my form, I reformat it into Currencies again. However, when I click on the field, it shows the number in its raw format. How can I fix this so that when the user click on the field, they won't see the raw number but just regular Currency format? Much thanks in advance.

 

[neileg]

I assume you are doing the calculation in a query. If you apply the format to the query, this should give you the behaviour you want.

 

[apoll0]

Yeah, I did the calculation in the query it self. I didn't know you can format it in the query also. Thanks. I'll try that.

 

[apoll0]

Ok, I formatted in the Query call using either FormatCurrency() or Format() and it works fine. However, now I can't sum up the field value at my form footer because apparently, the fields are represented as String...

Is there another way to format currency that I don't know of?

 

[apoll0]

I've settled with using Round() in my query instead, which round up the number so it doesn't look messy, and it allows me to sum up the field...
Wonder if there's another way.

 

[Rich]

You don't have to use the Format function, have you tried setting the Format to Currency in the query property sheet?

 

[apoll0]

I tried what you suggested, but the raw number with long decimal places is still there if i click on the field to edit.

So for now, Round() works, because I also formatted the form to display currencies after rounding.

Thanks Guys.

 

[elsandalos]

Ok, I formatted in the Query call using either FormatCurrency() or Format() and it works fine. However, now I can't sum up the field value at my form footer because apparently, the fields are represented as String...

Is there another way to format currency that I don't know of?

I'm trying to use Format and FormatNumber, and getting the same problem. Why does this happen? I'm getting a 'data mismatch' when trying to use a numerical criteria on a query field that uses FormatNumber to change the number of decimal places displayed.

FormatNumber is converting the field to a string - i can tell this because the field is left justified when viewing the query results, as well as the criteria not working, of course.

El.