where does access save columnwidth of sheetview

  • Thread starter Thread starter Nhan
  • Start date Start date
N

Nhan

Hi,
where does access save the inform columnwidth of each column (or control) of
a form in sheetview?
When I open an instance of a form as following, then access doesn't save
inform columnwidth. I want to save with VBA.

Thanks in advance for any help or advice

Nhan
 
See the ColumnWidth property of the control. (Available in Datasheet view at
run time)

This test event procedure may help (substitute myField with your fields
name)

Private Sub myField_GotFocus()
MsgBox (Me.myField.ColumnWidth)
End Sub

HTH, Graeme.
 
Back
Top