Currency Field Formatting - Simple but Annoying Issue!

[manix]

Hi All,

This is my first post so can I just say how great and useful this forum has been for me since I joined! I have found pretty much everything I have wanted without having to ask, so thank you everyone!

I am only beginning with Access at the moment, as I try to implement some improvements to the way my company works!

I have one really simple, but annoying issue at the moment and I cannot find the answer anywhere!

I have a currency filed in my table. I want to format it in USD, but USD is not available in the format options, just £ and €. I cannot see where the hell I get the USD $ format from?

I know this is probably well simple and I am being a plum!

 

[mhartman]

Hello:

place this in the format section for your field:

$#,##0.00
Regards
Mark

 

[manix]

Hello:

place this in the format section for your field:

$#,##0.00
Regards
Mark

Thanks, that has worked. I appreciate the response.

 

[mhartman]

Hello:

Your welcome, and good luck with this.

Regards
Mark