DATAGRID?

[ChrisM]

Does anyone know how to set the format of a DataGrid column, where the DataGrid is bound to an ado recordset at runtime?

[JHausmann]

If it's anything like DAO, it's one of those things about bound controls that bother me.

With DAO, formatting (on the bound fields) is lost when the update method is issued. You need to re-format the bound fields after the ".update" occurs.

[ChrisM]

The recordset is bound at run time (set datagrid.datasource = Rs). What I want to do is set the format of a particular column at run-time after the grid has been bound to the recordset.

[VorTechS]

Well, if your refering to column sizes etc...

The syntax is something along the lines of:-

dbgrid1.colums(0).width = 3000
dbgrid1.columns(0).caption = "Hello"

By default I don't think VB shows these properties with the auto-complete.

[ChrisM]

I was actually refering to the column format, i.e Boolean, Short Date etc.

[JHausmann]

The answer, then, is most likely no. The data types of the columns are determined by the bindings. You might want to give some thought to having two grids, one bound, the other unbound that overlay one another.

[ChrisM]

Unfortunately the recordsets I am dealing with are disconected and are bound at run-time. To bind a grid to a dataanvironment or data control would compomise the structure of the application.

[Emon]

try right clicking on the control in design time and bring up the properties box. There is a list of formats under the column tab and in the Number Format drop down box you can choose the format you want to put into your code. Remember to use quotes.