David i was going to reply to just one section of this yesterday but did not get time to find my code.
You mentioned problems with getting best object size to work with listbox columns..i cant remember if i had a problem or just never really tried using it on the list box column. When i was trying to to this i used a ‘dummy’ object on my form to put the data into(the object font etc set to match the LB column) and tested the data in there.(distinct values..find widest data(loop)) I cached the results-because you dont really want to do that every time-too slow on million plus records-but faster then you might expect…. ..and only did it on text (and string then) fields-i use better techniques on pictures and a different strategy for sizing numbers(although here is it good to contextual to the users-if you have customers that do invoices that are all less then 10,000 dollars and others that do invoices of 1,000,000,000 you dont really want to size for the 1,000,000,000 on the customers that do 100,000 max. I used this to optimize column widths overridding defaults that had been set there were not valid. Nigel Greenlee ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
