Making fields invisible in Datasheet view (1 Viewer)

[KeaganQuilty]

Is there any way of making fields invisible in datasheet view?

I have a subform (datasheet) with ten combo boxes on it. However, no more than six of them should be visible at any one time, based on criteria provided on the main form.

This form in tracking student attendance on a weekly basis. Each course can have up to six time slots. i.e. "Monday Morning", "Tuesday Afternoon", etc.

How can I make it so that only the time slots for which the course in scheduled show up in the datasheet?

Keagan Quilty
Kilbride, Newfoundland

 

[pcs]

datasheet view gives you very little control over how data is presented. you might try using the ColumnHidden Property...

hth,
al

 

[KeaganQuilty]

That did the trick. Thank you very much.

Keagan Quilty
Kilbride, Newfoundland