Formatting a calculated field in a query

[Guest]

Hello,

I have a calculated field in a query which I have formatted to be currency
but everytime I run the query the format reverts back to being blank and the
data in the actual query appears as being 4 numbers before and after the
decimal place.

Any suggestions on how I can get this field to stay formatted as currency?

Thanks.

 

[Rick Brandt]

Hello,

I have a calculated field in a query which I have formatted to be currency
but everytime I run the query the format reverts back to being blank and the
data in the actual query appears as being 4 numbers before and after the
decimal place.

Any suggestions on how I can get this field to stay formatted as currency?

Are you worried about what it "looks like" or what "value it contains"?

For the former only worry about that in the final output (form or report). The
format property doesn't affect anything but appearance and there should be no
reason to look at a query datasheet directly.

You might also try the Format() function instead of the Format property. That
will guarantee a certain appearance, but of course to achieve that it converts
the value to a string.