Solved Column widths not retaining for datasheet form

[Kayleigh]

Another frustrating issue is I have several subforms which are datasheet view. I would like to expand the column widths but it will not save when I close and re-open.
Any workarounds?

 

[Pat Hartman]

This is pretty frustrating. Old versions of Access handled the widths better. The user could even adjust and save the widths to suit himself. I don't have code but if you search, you might find some here to set the column widths as a form opens.

 

[bob fitz]

Another frustrating issue is I have several subforms which are datasheet view. I would like to expand the column widths but it will not save when I close and re-open.
Any workarounds?

What version of Access are you using?

 

[Kayleigh]

Office 365

It seems to be a bug. The workaround I have found for this is to open the unhide fields dialog box.

 

[bob fitz]

Office 365

It seems to be a bug. The workaround I have found for this is to open the unhide fields dialog box.

I'm using A2019 which seems to work without this problem.

 

[isladogs]

Users can still adjust and save column widths.
Or you can autosize datasheet columns by setting column width property to -2 in code