🚀 go-pugleaf

This should help:

Private Sub Form_Load()
    Dim i As Integer
    Dim d As Double

    d = 10#

    For i = 1 To 5
        MSFlexGrid1.Row = i
        MSFlexGrid1.Col = 1
        MSFlexGrid1.Text = Format(d, "###,###.00")
        d = d + 10#
    Next
End Sub

Eric
"Editions Doc" <editions.doc@wanadoo.fr> wrote in message
news:8o65l3$3js$1@wanadoo.fr...
> Hello,
>
> I'm currently looking for a way to have my SQL query (inside VB6) display
> decimals after the request in a msflexgrid (linked to a DATA control).
> For example, I have two prices : 12,30 and 42,00 (stored in a database).
My
> SQL query searches for prices higher than 10. So, my two prices are OK,
and
> are diplayed inside the MsFlexGrid, but My two decimals from the 42,00
> price, aren't shown (42 is displayed, and not 42,00).
>
> Here is the SQL query I use (on a command button click) :
>
> MsFlexGrid1.Datasource = Data1
> ' Table name : prices
> ' Field in table prices : price
> Data1.RecordSource = "SELECT price FROM prices"
> Data1.Refresh
>
> Thank you for your help !
>
> Bye ;-)
> Alex.
>
>
>