Results 1 to 1 of 1
Thread: Lock Column Width
2001-05-07, 14:06 #1
- Join Date
- Jan 2001
- Bethel, CT, USA
- Thanked 0 Times in 0 Posts
Lock Column Width
I'm running Access 2000. I have a "form view" main form containing a subform in "datasheet view". I'd like to be able to prevent users from changing the column width in the subform or at least not preserve changes made.
I've been unable to find any obvious documentation on this. If I need to do it through VBA that's O.K., I just thought there should be a simpler way, like a property setting or something.
One of the things that confuses me is when does Access decide to save changes to the column width. If I make changes by dragging the column width, sometimes it will show the changes when reopened and sometimes not.
What am I missing? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
Any help is always appreciated.