[AccessD] Ok, Let me ask it a different way.. (was: Subform colummn adjustment?)

Hi Robert

Fine!
As for the bloating, perhaps you could rewrite the code to perform an update of existing records and append if missing. Deleting all records sounds a bit primitive in this case.

/gustav

>>> robert at servicexp.com 18-01-2006 13:57 >>>
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 
******************************************