Number format on forms

  • Hi All

    I'm working with forms in VBA.
    On my forms I have a textbox that shows (for eg) annual profits. This figure can become quite big. Can I display this output using a number format that uses a comma to separate multiples of 1000 (eg, 1,000,000,000 instead of 1000000000)


  • Re: Number format on forms

    Hi Freddy,

    In the BeforeUpdate or AfterUpdate event of the Textbox, put TextBox1=format(TextBox1,"#,##0")

    I have used TextBox1, change to whatever yours is called.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!