DBGrid hide columns........

I have a DBGrid with Columns that I require, however I change the RecordSource to the DBGrid on several occasions this is to save hiding three diferent DBGrids.

As you can Imagine there are unused columns showing in the dbgrid which means you have to scrole to see parts of the data.

Is there a way to hide columns on run time?


thx:)

set colWidth property=0

Is there not like:


dbgrid1.column(0).hide or somthing?

if I hide the columne does that not mean when changing RecordSource I have to make it go back to its orginal size?:)

Dim Col1 As Column, Col2 As Column

Set Col1 = DBGrid1.Columns(0)
Set Col2 = DBGrid1.Columns(1)

Col1.Width = 0

OR INSTED OF SETTING COLWIDTH=0 ,

YOU CAN SET VISIBLE PROPERTY OF THE COL=FALSE

COL1.VISIBLE=FALSE

Thx OLa I think I'll go with Visible, havnt got VB on this PC I'll try It at work

Thx;)