Format Label.Caption or Textbox data

I preload labels.captions from worksheets as the form loads. Some are
Dollar amounts and would like to present them with commas and $. the $ is
easy to add but the commas are tough without a format type. Is there any
way to set the format on a label.caption or textbox as you do in cells,
i.e., Currency?
Thanks, Rob

Label1.Caption = Format(12345.78,"$#.##0.00")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RobC" <[email protected]> wrote in message
news:[email protected]...
> I preload labels.captions from worksheets as the form loads. Some are
> Dollar amounts and would like to present them with commas and $. the $ is
> easy to add but the commas are tough without a format type. Is there any
> way to set the format on a label.caption or textbox as you do in cells,
> i.e., Currency?
> Thanks, Rob

That worked PERFECT. Couldn't find that info anywhere. Thanks for the
help.

"Bob Phillips" <[email protected]> wrote in
news:ujXv8BD#[email protected]:

>
> Label1.Caption = Format(12345.78,"$#.##0.00")
>