Hide/Unhide columns in a continous (not datasheet) form.

[ser01]

I have a continuous form with some 100+ records on it. The form has 7 different fields. I would like to be able to hide some of them. This is easy to do with datasheet form - either manually or with a macro. Is there any way to do this? Or is hiding/unhiding columns on a form impossible outside of the datasheet view? The reason I can't use a datasheet form to begin with, is because in need some of the field labels to be vertical, and that is not possible with a datasheet form. Also some of the field labels are modified dynamically with VBA, and that seems to also not work in a datasheet form. Any suggestions would he highly appreciated.

[Bob Fitz]

Hi ser01,

I'm not sure if this helps but you did say that "Any suggestions would he highly appreciated."

1) You could use the On Current form event to hide/show any control on the form given a certain criteria. The disadvantage with this when using a continuous form is that the hidden/shown controls are hidden/shown on every record depending on the criteria of the current record.

2) You could use conditional formatting for text boxes and combo boxes to change the font colour to that of the control's background and set the enabled property to false. The disadvantage of this is that it dosen't hide tha actual control, just makes it look blank and stops users from entering data into it.

Hope this helps.