Gustav Brock
Gustav at cactus.dk
Wed Jan 18 04:27:50 CST 2006
Hi Robert I don't think there is an event for this, but even so why not just loop the fields and record the current ColumnWidth when you close the form. Then, when opening the form, read and set the ColumnWidth for each field. ColumnWidth contains the width in twips. Value -1 is for default width while -2 is for "fit to data" as if you double-click the header. You could do the same for the RowHeight of the form (or reset it). This is in twips as well, and -1 for default height. /gustav >>> robert at servicexp.com 17-01-2006 23:50 >>> Is there any way to capture the user adjusting a column or row? I don't see any events for such, but is there a different way... The more I think about this, maybe using a right click function for a "save dimensions" in a table type thing....???? ****************************************** Is there ANY way to allow a user to set the column width and row height (datasheet view) to their choice and SAVE that choice in an MDE? Robert Gracie www.gbsysnow.com ******************************************