Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Reseting ColumnWidth property (Access2000)

    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?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Reseting ColumnWidth property (Access2000)

    Well, out of frustration I finally just deleted those 2 controls, then recreated them by copying them over from the other controls that worked. Now everything is fine! But I still don't understand why they wouldn't work originally. Very annoying.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •