Brad Marks
BradM at blackforestltd.com
Fri Dec 3 16:31:39 CST 2010
Shamil, Thanks for the assistance. Your code worked nicely. Sincerely, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Friday, December 03, 2010 3:51 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Can VBA be used to "UnHide" columns in a Query inAccess2002? 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.