- Joined
- Jan 17, 2007
- Messages
- 1
- Reaction score
- 0
Michael Kaplan's paper on datasheets
http://msdn2.microsoft.com/en-us/library/aa217449(office.11).aspx states,
"If you need to do the same task with a Form [resize columns programatically to display the data currently in the column], it's even easier: Just set all of the ColumnWidth properties to -2. No extra steps are needed."
So in the Form_Open event procedure on my tabular form I'm setting the ColumnWidth property of each control to -2. But the datasheet view does not properly size the columns. What am I missing?
Thanks much!
http://msdn2.microsoft.com/en-us/library/aa217449(office.11).aspx states,
"If you need to do the same task with a Form [resize columns programatically to display the data currently in the column], it's even easier: Just set all of the ColumnWidth properties to -2. No extra steps are needed."
So in the Form_Open event procedure on my tabular form I'm setting the ColumnWidth property of each control to -2. But the datasheet view does not properly size the columns. What am I missing?
Thanks much!