Having trouble formatting a column that was added to a grid

Yahoo Archive
1
Duh! I missed the "string".
> .Bands(0).Columns("ExtPrice").DataType = GetType(String)

This fixed it.
.Bands(0).Columns("ExtPrice").DataType = GetType(Double)

Guess it is Monday.

--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> Hi,
>
> I am having trouble formatting a value in a grid.
> No format line I've tried has had any effect.
>
> Anybody know what I might be missing?
>
> Here is a the code adding the column to the grid.
> The cells are populated with a decimal value returned from a calculation. (Trailing zeros aren't currently displayed either).
>
> With grdList.DisplayLayout
> .Bands(0).Columns.Insert(.Bands(0).Columns.Count, "ExtPrice")
> .Bands(0).Columns("ExtPrice").DataType = GetType(String)
> .Bands(0).Columns("ExtPrice").Format = "#,###,###,##0.00000"
> End With
>
>
>
> Thanks
>
2
Hi,

I am having trouble formatting a value in a grid.
No format line I've tried has had any effect.

Anybody know what I might be missing?

Here is a the code adding the column to the grid.
The cells are populated with a decimal value returned from a calculation. (Trailing zeros aren't currently displayed either).

With grdList.DisplayLayout
.Bands(0).Columns.Insert(.Bands(0).Columns.Count, "ExtPrice")
.Bands(0).Columns("ExtPrice").DataType = GetType(String)
.Bands(0).Columns("ExtPrice").Format = "#,###,###,##0.00000"
End With



Thanks