formatting the data in a datagrid

[Robert Batt]

Hello,
I wish to format the data in one of the columns of a
datagrid so that it does not display more than 3 decimal
places. I have a datagrid call dgjobs and I have the
following code.

nb cm is a currency manager
Dim i As Integer


ts = New DataGridTableStyle(cm)

Me.dgjobs.TableStyles.Add(ts)

ts.GridColumnStyles(11).Width = 50
ts.GridColumnStyles(11).HeaderText = "B/C"
ts.GridColumnStyles(11).NullText = ""

How do I restrict the data in this column 11 to show only
3 decimal places

thanx in advance

Robert

[Nicole Calinoiu]

Robert,

Try using the Format property of the column style. e.g.:

ts.GridColumnStyles(11).Format = "F3"

HTH,
Nicole


"Robert Batt" <robertxxxx@yahoo.com> wrote in message
news:22be701c38be6$1cf47e70$a601280a@phx.gbl...

> Hello,
> I wish to format the data in one of the columns of a
> datagrid so that it does not display more than 3 decimal
> places. I have a datagrid call dgjobs and I have the
> following code.
>
> nb cm is a currency manager
> Dim i As Integer
>
>
> ts = New DataGridTableStyle(cm)
>
> Me.dgjobs.TableStyles.Add(ts)
>
> ts.GridColumnStyles(11).Width = 50
> ts.GridColumnStyles(11).HeaderText = "B/C"
> ts.GridColumnStyles(11).NullText = ""
>
> How do I restrict the data in this column 11 to show only
> 3 decimal places
>
> thanx in advance
>
> Robert