Datasheet question

[Phil Hunt]

Is there anyway to fix the columne width on datasheet subform in Acc 2007. ?

Thanks

 

[Arvin Meyer [MVP]]

You can use the resize event and the current event of the form, and the
lostfocus event of the control, to return the column to it's width:

Private Sub Form_Resize()
Me.txtControlName.ColumnWidth = 1440 ' 1 inch
End Sub

There are 1440 twips to the inch.

 

[Phil Hunt]

thanks.

You can use the resize event and the current event of the form, and the
lostfocus event of the control, to return the column to it's width:

Private Sub Form_Resize()
Me.txtControlName.ColumnWidth = 1440 ' 1 inch
End Sub

There are 1440 twips to the inch.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com