hi

I have control array of Textbox. Text1(0),Text1(1),Text1(2),Text1(3),Text1(4). The textbox are formatted as Number(with comma after 1000).
Below is the code:

Sub Text1_Change(Index as Integer)
Select case Index

case 0 Text1(2)=val(Text1(0))+val(Text1(1))

case 3 Text1(4)=Val(Text1(2))+Val(Text1(3))

End Select

Everything works fine, except one problem. When its add the value ot Text1(2) and Text1(3), such as 123,456+123,456, it display value in Text1(4) as 246 only, while it should display 246,912. But when i remove the textbox format, it displays 246912. I want the format as well as the value to be displayed as 246,912.

Any alternative way to do this.

Thanks