FormatbyCriteriaSubClass from Stephen Lebans

[takilroy]

Hi,


Has anyone been able to get this example (found here:
http://www.lebans.com/formatbycriteria.htm) to work in Access 2003? I
converted it, and it dies (memory leak it looks like) on exit of the
SubClassFormatByCriteria form during the unhook. If I comment out
unhook, it looks to work, but then using the scrollbar causes the
colors not to follow the row.

Any help would be appreciated.

Thanks,
Teresa

 

[Stephen Lebans]

That solution was written explicitly for A97 and not for A2K or later.
You would need to remove the module level subclassing code into an external
DLL due to a bug with subclassing and the VB IDE.


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[takilroy]

Do you know if there is any way to work around the bug with subclassing
(is it listed on Microsoft anywhere?)? I have a continuous form that
uses the methods you've written and now we are upgrading to Access
2003, so I need to do something.

Thanks,
Teresa

 

[Stephen Lebans]

If you can guarantee that the VB IDE window will never open during the
session, such as running the app as an MDE, then you can simply replace the
call to AddrOf with the native VB AddressOf method.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.