I may not have been as clear as I could have been.... For the purposes
of one particular query, I want to display a currency field, as a
number, with 2 decimal places. If the situation was reversed, I
suppose I could define a number formatted field as CCur[FieldName] and
have the query display it in currency format, but how do I acheive the
opposite?
Since a currency field is a kind of number, all the number
formats apply and there is no need toconverta currency
type just to format it. If the field were a Text field,
then you would need toconvertit and converting it to
currency would probably be the best way to handle it.
Did you try setting the text box's Format to 0.00? If you
did, what happened? If you did not try it, give it a shot
and see what happenes.
--
Marsh
MVP [MS Access]- Hide quoted text -
- Show quoted text -