Column width in subform needs to match label's width

[newbieX]

I have a subform that is displayed as a datasheet (I do not want it continuous). One field is a check box but the label (column header) is about 20 characters long and is truncated in the datasheet view. How can I programmatically adjust this column width when opened so that the width matches the label's width?

[Missinglinq]

Private Sub Form_Load()
  Me.ActualTextboxName = -2
End Sub

Replacing ActualTextboxName with your actual name.

You might be interested in this article 'You Can Do That With Datasheets?'

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

Linq ;0)>

[CJ_London]

Think you missed a bit linq!

Me.ActualTextboxName.columnwidth = -2

[Missinglinq]

Oops! Had a ridiculously long Control name for testing (hadn't done this in a while) and when replacing it with a better name, for posting, left that off!

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

Thanks for the assist, Ajax!

Linq ;0)>