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)


    Freddy

    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.


    Bill

Participate now!

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

Register Yourself Login