Access Currency Formats

[David S]

I have a report requirement to show dollar amounts with a fixed
position dollar sign:

$ 10.00

This is easily accomplished in Excel by selecting the Accounting format
or using a custom format like "$* #,##0.00". However, I can't seem to
get an Access Text Box on a report or form to display currency in this
way. I've tried using the Format function with a variety of formats,
but I haven't found one that gives me what I'm looking for. I've also
tried FormatCurrency without success. Any ideas?

Thanks, David.

 

[Marshall Barton]

I have a report requirement to show dollar amounts with a fixed
position dollar sign:

$ 10.00

This is easily accomplished in Excel by selecting the Accounting format
or using a custom format like "$* #,##0.00". However, I can't seem to
get an Access Text Box on a report or form to display currency in this
way. I've tried using the Format function with a variety of formats,
but I haven't found one that gives me what I'm looking for. I've also
tried FormatCurrency without success.

That exact same custom format works fine in the Format
property of a text box.

 

[David S]

Thank You!

I think I had tried your suggestion before in one of my many different
attempts to get the fixed position dollar sign to work in my report,
but it had not worked for me. After receiving your comment that
putting the custom format in the text box does in fact work for this I
tried it again, but it still did not work. I noticed though that I was
moving to the specially formatted text box (unbound) from another text
box (bound) in code. It occurred to me that perhaps the formatting was
getting lost in the move somehow. I tried moving the first text box to
a Currency variable and then from the variable to the specially
formatted text box and it worked!

Thanks again - this one had me stumped.

-- David.