determining selected columns in datasheet

M

Malcolm Cook

Hi,

I can't figure out if it is possible to determine the controls behind the
current selected columns in when a form is in datasheet view

I know how to get the .selleft and .selwidth, but, since columns can be
hidden and rearranged, I don't think I can use these in figuring this out.

I even started in on an approach that compares each ctl.ColumnHidden state
before and after calling DoCmd.RunCommand acCmdHideColumns. What a hack!
It works except for one problem... too bad for me, acCmdHideColumns only can
hide a single column at a time. Its as if the access engine itself does not
know what columns are currently selected.

Any takers?

Thanks,
 
Top