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]
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