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