[AccessD] Observations on AC 2007 (not good)...more

Mark,

What about Right-Clicking on column's header -> Hide Columns ?
Also main menu Format ->Hide/Unhide Columns? (There should be equivalent in
one of the Ribbon tabs - I do not have MS Access 2007/2010 running here now)

.ColumnHidden is there in MS Access for a long time, since Access 97 at
least.


Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: 30 ?????? 2010 ?. 5:47
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Observations on AC 2007 (not good)...more

Here's more on 2007....
I was reviewing a copy of the Tradewinds application rewritten for 2007.
There was a subform set to datasheet view that only displayed a few selected
columns...
It was the subform in the Employee Detail form that showed the related
orders to the salesperson.
I could not find a property to "hide" the fields on the subform.
After some research, I ran some VBA code in the Activate event handler, and
was able to determine that there was an unexposed property called
ColumnHidden. Sure enough, it was set to "True" for the columns not showing
up.
However, it remains a mystery how they ever got set that way in the first
place....there was no VBA proc in the modules to do this. It appears as
though "someone" coded it, and then erased it.

<<< snip >>>