Auto resize the datasheet form (1 Viewer)

[gstylianou]

Good evening,

I would like to ask if there is a way in a Datasheet View form the colums can automatically resize depending on the data available. I tried many solutions but unfortunately I didn't found any way.....

I will appreciate any help

Thanks

 

[Ranman256]

if you open a datasheet alone, it will resize itself.
if you open a sheet IN a form, then youd have to resize it to the form, for the screen displaying it.

sub form_resize()
  child.width = me.width -10
  child.height = me.height -20
end sub

 

[gstylianou]

Hi Ramman,

It doesn't work..! Actually its not what i ask to do. I need to resize the column width...

 

[speakers_86]

There is a value you set the width to which tells Access to automatically size it based on the data. I believe the value is -1 or -2. I don't remember.

 

[JHB]

It is -1 for Autoresize depending of the data width.
-2 is for Autoresize depending of the control label width.

Private Sub Form_Load()
  Me.YourControlName.ColumnWidth = -1
End Sub