How to format a textbox?

I'm using RS 2003. Have a textbox with a number in it, but somehow the "Format" filed doesn't work or do anything ! I tried "#,#", (#,#), "#,##0", etc.

So, how do I set the format on an individual cell Thanks.




Answer this question

How to format a textbox?

  • alwz_nikhil

    YOu hjave to do that without quotes or use a named format like n2.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---


  • thenowayman

    Could it be that your .Value was recognized as text Text Values / references are automatically aligned to the left side, numeric ones to the right side.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • PieterE.care

    I did try that one too! Didn't work! I even used Standard Format and didn't work!

  • blackcatsbones

    You were right. I had to use Val() function in order to use the Format. Thanks.

  • How to format a textbox?