Sizing labels

[Guest]

Is it possible to have forms size lables automatically upon opening in
datasheet view to show all text/#s in cells rather than manually resizing
every time or setting column width per form permanently.

Thanks

Matt

 

[Arvin Meyer [MVP]]

In the GotFocus event, or any event which fires when entering the control, a
bit of code like:

Me.[txtMyTextbox].ColumnWidth = -2
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access