Results 1 to 3 of 3
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Does anyone know of a way to Dynamically Freeze columns on a Form in DataSheet View

    Code:
    [FieldToFreeze].SetFocus
    DoCmd.RunCommand acCmdFreezeColumn
    It seems strange that you can set the ColumnOrder, ColumnWidth and ColumnHidden properties of a DataSheet view along with other DataSheet properties,
    but the Frozen Columns can only be set using a RunCommand.

    I may have missed a new property in 2010 but I don't think so.
    Andrew

  2. #2
    Lounger
    Join Date
    Jun 2010
    Location
    Manchester, NH
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Here is an article from MSDN which might be of some help

    http://msdn.microsoft.com/en-us/library/aa217449(office.11).aspx
    Bob Oxford
    Software Wizards, Inc.

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Thanks.
    I'd had a look at that, and although it uses a Macro for freezing columns, it still relies in focus.
    It would appear that in all those properties and methods, there are none that allow manipulation of frozen columns.
    Pretty much everything else.
    You wonder what the object model was to prevent having a froxen column property of method.

    Access 2015 then?
    Andrew

Posting Permissions

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