visibility in datasheet view

[Guest]

I have sent a control in my form to:
Me.LENGTH.Visible = False

It works in form view but doesn't work in datasheet view. Any ideas about
how to make it disappear when in datasheet view?

Heidi

 

[John W. Vinson]

It works in form view but doesn't work in datasheet view. Any ideas about
how to make it disappear when in datasheet view?

I don't think you can, other than by setting the width of the entire column to
0.

I'd suggest using a Continuous Form rather than datasheet view. It gives you a
lot more flexibility, and can be made to look very much like a datasheet. The
only thing you can't do (but IMO would want to do anyway!) is give the users
the power to resize rows and columns.

John W. Vinson [MVP]

 

[Guest]

I will try it, thank you so much!

I don't think you can, other than by setting the width of the entire column to
0.

I'd suggest using a Continuous Form rather than datasheet view. It gives you a
lot more flexibility, and can be made to look very much like a datasheet. The
only thing you can't do (but IMO would want to do anyway!) is give the users
the power to resize rows and columns.

John W. Vinson [MVP]