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?

 

[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