Hiding and Resizing Columns

[mr_e_landis]

What I have: I have a main form with 3 subforms viewed as datasheets.

I have read the post about hiding columns by using me.<object>.columnhidden = True and that kind of works. Once the user goes to resize the columns they can get the hidden columns back. This is a problem if I'm trying to hide a priority column only admins should see.

Is there a way to specify the width of a column and restrict the user from resizing it? That way the user can not resize and get hidden columns back.

If there is a better way if doing this please let me know. Ultimately, I just don’t want the user resizing or unhiding columns I have sized and hidden.

Thanks

 

[trucktime]

Forms

Instead of Datasheet you can set it to Continuous Forms.
A lot easier to format and control.