Can I hide field in Datasheet view? 2

[ksbigfoot]

I am using MS Access 2003.

I have 2 subforms on my page displayed in a datasheet view.
If I pick a value of "One" on my top subform, I want to only show 2 of the 3 fields in the second subform.
My columns in my second subform are called: Col1, Col2, Col3

Top subform value of "One" picked
Display: "Col1", "Col2" in second subform

Top subform value of "Two" picked
Display: "Col2", "Col3" in second subform

Without duplicating the second subform so there is two instances, is there a way I can hide and display fields as I need?

Thanks

 

[Remou]

Have a look at the ColumnWidth and ColumnHidden properties.

 

[ksbigfoot]

Howdy Remou,

Star to you. That worked perfectly.

ksbigfoot