Formating data grid

I wish to show some items in data grid

i Need 4 columns in grid. I want format 3 and 4 the column in the format 1000.25 , 775.55 like that

1. How can i format 3 and 4 the column ?

2. I need More width in column 1 to to show more value, How can increase column width ?

A.Senthil kumar

[292 byte] By [image] at [2008-1-23]
# 1
Please correct above question
MY OS windows XP
Visual Basic 6 Enterprise Edition
I wish to show some items in data MSFLEXGRID
i Need 4 columns in FLEXGRID. I want format 3 and 4 the column in the format 1000.25 , 775.55 like that (original value 1000.75251414)
How can i format 3 and 4 the column only ?
MY Present code is
Private Function filldetail()
On Error Resume Next
Set rs = New ADODB.Recordset
rs.Open "Select prd_name,qty,rate,tax,amount,rid from pur_det where trans_id=" & Trim(txttransno.Text) & "", cn, adOpenStatic, adLockPessimistic
With msfdetail '('flexgrid name)
ColWidth(0) = 2200
Set msfdetail.DataSource = rs
End With
rs.Close
End Function

A.Senthil kumar
image at 2008-1-23 > top of Msdn Tech,Visual Basic,Visual Basic General...