I would like to know how to refresh the datasheet in my subform to have the column width set as Best Fit. I know that there is a ColumnWidth property and if you set it to -2 it will set it to the best fit size. But I want to know how to access that property (i.e the syntax). Basically I want to loop through all the columns and set the ColumnWidth to best fit after the recordsource has been set. TIA.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Auto resize column width on subform table.
- Thread starter djmc
- Start date
- Status
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Helpful tip
