Formatting currency

[Jeanette]

I have used NZ([funds]) on a currency field. My numbers now appear like this 1234567. I want them to appear like this $1,234,567. How do I format this field to appear as dollar amounts and incorporate the NZ() function? Thanks in advance.

 

[Jon K]

Use the CCur() function:-

CCur(Nz([Funds]))

 

[Jeanette]

Currency

Thanks a lot it worked!