[AccessD] Can VBA be used to "UnHide" columns in a Query in Access2002?

Hi Brad,

The following VBA code will toggle second column's visiblity:

- On 

Screen.ActiveDatasheet.Controls(1).ColumnHidden = false

- Off

Screen.ActiveDatasheet.Controls(1).ColumnHidden = true 

provided your query is opened in normal view and has focus

Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: 4 ??????? 2010 ?. 0:15
To: Access Developers discussion and problem solving
Subject: [AccessD] Can VBA be used to "UnHide" columns in a Query in
Access2002?

Can VBA be used to "UnHide" columns in a Query in Access 2002?

Thanks,
Brad


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com