Formating the Caption of a label

Is there away to format the caption of a label as follows.

I want to be able to put commas in a label that contains only numeric data. There is no text at all. Right now the label look like this "1000000" I would like to change it so it looks like this "1,000,000"

Thanks

Ken Devorak

Hmm,
as far as I know, its simply:

Label1.caption = "1,000,000"

Unless you really want a function that automatically formats
the caption.

If you do, I'll whip something up in a minute.
Just say so.

:) :) :)
-Lou

I did do the whole label.caption = 1,000,000 but when I do a calculation on it as follows I losse the commas.

label.caption = label.caption + intXXX

Sorry, I was a little busy.

So, check out the format function.
Heres an example:

Label2.Caption = 1234567
Label2.Caption = Format(Label2.Caption, "###,###,###,###,###")

This ends up as 1,234,567 in Label2.

-Hope this helps,
-Lou