Image List & Commas

[ProjectExplorer]

I am using an image list in MS 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 Image list, all the formatting (i.e. commas) dissappear so it appears as 100000.

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

Any help appreciated.

Thanks.

 

[CautionMP]

...when I load the data from the table into my Image list...

Huh?

The Windows Forms ImageList component is used to store images, which can then be displayed by controls.

Do you mean a ListBox? If so you need to convert your numbers to formatted strings in the code you use to load the ListBox.

CMP


[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[ProjectExplorer]

Thanks for responding to my thread "CautionMP".

I did indeed have a mad moment and should have referred to the ListView control NOT the ImageList. It was late in the day and I had far too many controls floating around my head at that point....

I solved the problem thanks to another thread and simply formatting the relevant nodes....easy when you know how and now obvious....but as I said it was late in the day.

Thanks again.

Regards.