where does access save columnwidth of sheetview

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
 
G

Graeme Richardson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top