ListView & Currency Formatting

[ProjectExplorer]

I am using an ListView object in Access and have set my data field to currency (standard) so that numbers appear with commas - i.e. 100,000.

However, when I load the data from the table into my ListView (Report Syle) list, all the formatting (i.e. commas) dissappear so it appears as 100000.

Can any one suggest how I can get the ListView to display numbers as Standard format with commas.

Any help appreciated.

Thanks.

 

[PHV]

When loading the nodes you may use the Format function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ProjectExplorer]

Thanks for your response "PHV". Formatting the nodes did the trick perfectly - makes perfect sense now.

It's obvious when you know how !

Regards