Hiding columns with no data in datasheet view

Robert Saye

Registered User.
Local time
Today, 16:41
Joined
Jun 19, 2000
Messages
49
Hi all,

I have a form with cascading textboxes, that select a group of records. The records open up on a subform. What I am trying to do is when I have a particular recordset open, I would like to hide any columns that are not being used. For instance in the practice contacts database that comes with Access 2000, the Region field is rarely used. I would like to hide that column if none of the records I pull up use it.

Any Ideas would be appreciated.
Thank You,
Robert
 

Users who are viewing this thread

Back
Top Bottom