Hello,
after installing SP2 in Office 2007, the property ColumnHidden doesn't work when I use a Split Form.
When I have a Split Form with the Datasheet on Bottom, if I try to hide a column in datasheet on FormLoad (ex: Me.ID.ColumnHidden=true) , the datasheet doesn't hide this column.
If I look this property I can see that columnhidden is updated and is true (ex: msgbox(Me.ID.ColumnHidden)) but the column is visible. I think that the datasheet does't refresh.
The only way that I find to hide the column is to set an event onDoubleClick to another column in datasheet, but I'm not satisfy to use this workaround. I need to hide the column on form load.
Please, anybody can help me?
after installing SP2 in Office 2007, the property ColumnHidden doesn't work when I use a Split Form.
When I have a Split Form with the Datasheet on Bottom, if I try to hide a column in datasheet on FormLoad (ex: Me.ID.ColumnHidden=true) , the datasheet doesn't hide this column.
If I look this property I can see that columnhidden is updated and is true (ex: msgbox(Me.ID.ColumnHidden)) but the column is visible. I think that the datasheet does't refresh.
The only way that I find to hide the column is to set an event onDoubleClick to another column in datasheet, but I'm not satisfy to use this workaround. I need to hide the column on form load.
Please, anybody can help me?
