How do you hide Columns in a SubForm - based on values in the datasheet

[STEVE FRY]

Hi, I have a very similar problem, but instead hiding based on column name, I need to hide based on data in the subform. So far I have this, which works, but it doe snot cycle through the data (it simply takes the first value and hides the column based of that).

I would appreciate any help,

Steve

Me!Child86.Form.[Concrete Accessories].ColumnHidden = IsNull(Child86.Form.[Concrete Accessories]) = True



JimBurke via AccessMonster.com wrote:

Re: How do you hide Columns in a SubForm
22-May-09

Here's a good link that has the 'rules' for referencing subform properties
and controls...

http://www.mvps.org/access/forms/frm0031.htm

Ayo wrote:

--
Jim Burke

Message posted via AccessMonster.com


EggHeadCafe - Software Developer Portal of Choice
WPF DataGrid Custom Paging and Sorting
http://www.eggheadcafe.com/tutorial...f-32b2d802ae17/wpf-datagrid-custom-pagin.aspx

 

[John Spencer]

Since a data sheet is homogeneous you can't show or hide a column in each row
depending on the value of the column in that row. The only time this could
work would be if you had a single record.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County