Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / December 2005

Tip: Looking for answers? Try searching our database.

Hiding columns across merged cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ZipCurs - 09 Dec 2005 22:18 GMT
From Excel, I can hide a single column even if it crosses merged cells,
without hiding all of the cells included in the merged set of cells.  If I
hide the column with a macro, all of the columns in the merged set of cells
are hidden.  How can I get the single column to be hidden without a lot of
unmerging and remerging of cells?
David Lloyd - 10 Dec 2005 00:20 GMT
One alternative is to set the ColumnWidth property to zero.  For example:

Columns("B:B").ColumnWidth = 0

If you want to unhide the column, you can resort back to the Hidden
property, or change the ColumnWidth property again.

Signature

David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.

From Excel, I can hide a single column even if it crosses merged cells,
without hiding all of the cells included in the merged set of cells.  If I
hide the column with a macro, all of the columns in the merged set of cells
are hidden.  How can I get the single column to be hidden without a lot of
unmerging and remerging of cells?
ZipCurs - 12 Dec 2005 19:46 GMT
That did the job.  I thought I had tried that, but apparently not!

> One alternative is to set the ColumnWidth property to zero.  For example:
>
[quoted text clipped - 8 lines]
> are hidden.  How can I get the single column to be hidden without a lot of
> unmerging and remerging of cells?
Pat Hartman(MVP) - 10 Dec 2005 06:01 GMT
Tables are not spreadsheets.  They do not have cells and they work nothing
like spreadsheets.  It's time to put on your relational database hat and use
database techniques to control the view of data rather than spreadsheet
techniques.  One thing that seems to cause a lot of confusion is the fact
that in a spreadsheet the data and presentation layers are combined.  That
means that the format of a spreadsheet dictates how data is stored.  With a
database, data and presentation are completely separate.  Tables store data.
Forms and reports display it.

> From Excel, I can hide a single column even if it crosses merged cells,
> without hiding all of the cells included in the merged set of cells.  If I
> hide the column with a macro, all of the columns in the merged set of
> cells
> are hidden.  How can I get the single column to be hidden without a lot of
> unmerging and remerging of cells?
David C. Holley - 10 Dec 2005 07:02 GMT
This is a newsgroup for ACCESS only.

> From Excel, I can hide a single column even if it crosses merged cells,
> without hiding all of the cells included in the merged set of cells.  If I
> hide the column with a macro, all of the columns in the merged set of cells
> are hidden.  How can I get the single column to be hidden without a lot of
> unmerging and remerging of cells?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.