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.

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

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||I did try that one too! Didn't work! I even used Standard Format and didn't work!|||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
|||You were right. I had to use Val() function in order to use the Format. Thanks.sql