OK, this is strange. I’ve got routines that save a user’s settings for a Datasheet (columnwidth, order, etc.), then restore them each time the user calls-up that datasheet. I use it all the time, and haven’t had any problems, until now.
For this one particular datasheet, there seems to be 2 columns which won’t accept a change in the .ColumnWidth property via code! On the screen, I can make then wider/narrower, and the settings are being saved correctly, but when the datasheet is opened again, the widths of these 2 columns fails back to the default. I even stepped through the code, and tried to change the columwidth from the immediate window! It just ignored any value I gave it. No error, it just ignored it.
I can’t see how these 2 objects differ from any others on the datasheet. For example, one of the objects that won’t resize is txtFee1Date. There is a txtFee2Date object which seems identical in all property settings, and which works just fine! There is also a txtFee1Amt object that works fine, but the txtFee2Amt object doesn’t!
I’m at a loss to explain this. Anyone have a clue as to why I can’t reset the columnwidth for these 2 columns?
