+ Reply to Thread
Results 1 to 3 of 3

Format Label.Caption or Textbox data

  1. #1
    RobC
    Guest

    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

  2. #2
    Bob Phillips
    Guest

    Re: Format Label.Caption or Textbox data


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

    --

    HTH

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


    "RobC" <rcsontos@hotmail.com> wrote in message
    news:7CYEd.218365$Oc.23033@tornado.tampabay.rr.com...
    > 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




  3. #3
    RobC
    Guest

    Re: Format Label.Caption or Textbox data

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

    "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in
    news:ujXv8BD#EHA.3260@TK2MSFTNGP14.phx.gbl:

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



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1