I have looked through other posts, but can't seem to do what I need to ! 

I have a field defined in the database as "Currency".  I have placed an Edit control on a form and specified ftCurrency as the FormatType.

OK so far, but it displays as (for example):  $123,456,789.00 and I would like to make it read $123,456,789 without the decimal point or decimal places.  Arguably I should have perhaps called the field Integer, but it will in fact contain only whole dollars.

I tried putting %.0f as a FormatString, but this ended up dropping the $ sign and the comma separators. 

Any ideas please?  I also would like to the same thing in a List View on the same data.

Many thanks!  Sorry in advance if I should have looked more carefully for an answer!

Hi Paul,

Try this. m is for money. You can access entire list of if you search for printf on the net if I remember correctly.

%.0m

Regards,

Jinsan

Brilliant!  Thanks Jinsan.  That works perfectly!