Robert Gracie
robert at servicexp.com
Wed Jan 18 06:57:24 CST 2006
Hello Gustav, Thank you VERY much for the directional help, It's appreciated. I wound up doing exactly what you described. I found a small project on Access Advisors, that used two classes and a table to do exactly what you described. With a little tweaking, I now have full control (allow, disallow, record and update changes) over column width, column order, column visible and row height. It accomplishes this in real time with the use of WithEvents. My only concern is with bloating, on exiting of the form the procedures deletes the records (field settings for that subform) and re writes the existing settings to the table. Thanks Again Gustav!! Robert Gracie www.gbsysnow.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Wednesday, January 18, 2006 6:01 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Ok,Let me ask it a different way.. (was: Subform colummn adjustment?) 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 ****************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com