Is there anyway to fix the columne width on datasheet subform in Acc 2007. ? Thanks
P Phil Hunt May 8, 2007 #1 Is there anyway to fix the columne width on datasheet subform in Acc 2007. ? Thanks
A Arvin Meyer [MVP] May 8, 2007 #2 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.
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.
P Phil Hunt May 8, 2007 #3 thanks. Arvin Meyer said: 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 Click to expand...
thanks. Arvin Meyer said: 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 Click to expand...
