How do I set size of colums in a table subform datasheet view in MS Access

Question

I have a subform bugging me. The mainform contains buttons etc. Everytime the user close/open the form, the columns width is reset to whatever the table likes. If i open the table directly, the size is as i want. If i change it in the subform, it is not saved. (See screendump)

I would like "Phase" to stay about 2 cm width. I can enter the subform and edit the "Width" but that is only applied to the other views.

I hope you can help, Emil.

Answer 1

I realize this post is almost 2 years old, but I ran into the same problem and came across this post.

I am running MS Access 2013 on Windows 7 Ultimate. I did not find the solutions offered here to work for me, so, I set out to find something that would work for me before I went to VBA code. (Incidentally, I appreciate the link offered by @Patrick_Honorez in his comment on the original post because that was going to be my fall-back solution.)

Anyway, here is what worked for me and I hope perhaps it will work for others as well:

1. Open the parent form.
2. In the subform, right-click the column header for the column for which you wish to adjust the width.
3. Select the “Field Width” item from the context menu.
4. In the “Column Width” dialog that appears in step 3, enter the desired column width in points, or, use the [Best Fit] button. Then click the [OK] button to close the dialog and return to the form.
5. Right-click the parent form’s border to bring up the parent form’s context menu. Click the “Save” item in the context menu.
6. Now close the parent form.
7. The next time the form is loaded, the column widths should be as set it step 4 above--at least they are for my setup.