We help IT Professionals succeed at work.

Access Resizing Columns of Sub Form

Murray Brown
Murray Brown asked
on
Hi

I have the sub form shown below in Access. I find it easier to resize each column in the "live" form rather than in design view. Is it ok to do it this way  or do I have to also do it in design view?
I have resized the first column but not the second in the image

Image1.JPG
Comment
Watch Question

Dale FyeOwner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010

Commented:
Murray,

I assume this is a datasheet, not a continuous form.

Generally, if you want the datasheet column widths to stay they way you want them, you should open the datasheet on its own, without the parent form.  Then set the widths of the columns, and save the form, as it is, still in datasheet view.  Then, when you close it and open it again, the column widths will generally remain the way you want them.

As an alternative, you might want to check out my Article (Customizing datasheets ...) which discusses a way to save the column widths in a table, specific to each user every time you close the form.  This way, users who use the same form in different manners can re-arrange the order of the columns, as well as their width.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Hi Dale. Thanks. Yes this is a datasheet form. Do I have to open the form on it's own in design view or can I open it in normal form view where it will be much easier?
Owner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010
Commented:
I do it in datasheet view.  You really cannot affect anything in design view.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Fantastic! Thanks Dale
Dale FyeOwner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010

Commented:
happy to help