Column Resizing in Datasheets

D

David Leblond

I'm having a very strange problem with Access 2003. I have a form that
includes a subform. In the form_load event, I set some of the column widths
to autofit like so:

[Some Field].ColumnWidth = -2

And this works fine on my computer. Unfortunately we have found a few
computers that this does not work on, instead it sets the column width to
about a quarter of the size it should be. These computers have the exact
same version of Office (2003 SP1) and Windows, so there is no reason they
should act differently.

Does anyone have any idea why this is happening? Its very frustrating,
apparently it does this at the customer site as well. By the way, the column
autofits fine when you do it manually.
 
Top