adjust column width in datasheet form

[Bospeentje]

Dear forum,

Anyone knows how to adjust the column width in a datasheet form permanently?

[ranman256]

Usu. you adjust width, and it stays.

[Bospeentje]

*&^%$#&^%^.....so I noticed!! Tnx
(must be the monday thing)

[Missinglinq]

Alternatively, you could program the columns to 'size-to-fit.'

For specific Controls:

Private Sub Form_Load()
  Me.Textbox1.ColumnWidth = -2
  Me.Textbox2.ColumnWidth = -2
End Sub

For all Controls containing data

Private Sub Form_Load()

Dim ctrl As Control

 For Each ctrl In Me.Controls
    
    If Not (TypeOf ctrl Is Label) Then
     
       ctrl.ColumnWidth = -2
       
    End If
  
  Next

End Sub

Linq ;0)>