hi,
i have the following code (vb 6.0, sp6, windows xp home, sp2):
DataGrid1.ClearFields
sSQL = "Select [boom], [volume], [total] From Logs_Inventory;"
Set RSTALL = New ADODB.Recordset
RSTALL.Open sSQL, objAccessConnection, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = RSTALL
DataGrid1.Columns(1).DataFormat.Format = "#,##0.000"
DataGrid1.Columns(2).DataFormat.Format = "#,##0.00"
DataGrid1.Columns(1).Alignment = dbgRight
DataGrid1.Columns(2).Alignment = dbgRight
it works - it displays data in datagrid, but all three columns are align to the left numbers are not formated at all.
i just don't see what's wrong...
i have the following code (vb 6.0, sp6, windows xp home, sp2):
DataGrid1.ClearFields
sSQL = "Select [boom], [volume], [total] From Logs_Inventory;"
Set RSTALL = New ADODB.Recordset
RSTALL.Open sSQL, objAccessConnection, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = RSTALL
DataGrid1.Columns(1).DataFormat.Format = "#,##0.000"
DataGrid1.Columns(2).DataFormat.Format = "#,##0.00"
DataGrid1.Columns(1).Alignment = dbgRight
DataGrid1.Columns(2).Alignment = dbgRight
it works - it displays data in datagrid, but all three columns are align to the left numbers are not formated at all.
i just don't see what's wrong...