469,908 Members | 2,212 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,908 developers. It's quick & easy.

Lebans Highlight Selected Row

Firstly, how the heck does this guy do it? Writing reams of (awesome)
code, debugging, responding to Newsgroups etc., all while commanding
the ridiculous price of FREE?!?!?! More power to him!

I'm hoping to use the Highlight Current Row functionality from the
FormatbyCriteriaSubClass database. My problem is that the highlight is
not scrolling. Selection rows works like a charm but the highlight
doesn't move when I scroll.

I am using Access 2003 on an XP machine. I have tried using the
database as is and also converting it to various other versions - no
go. I am prone to breaking things but I get this problem right out of
the box (zip file) without any modifications.

Oh yeah, why on earth has MS not implemented this functionality? Among
the 40,000 other gripes, this is surely one of the more common.

Thanks.

Nov 13 '05 #1
2 8384
That solution is for Access 97 ONLY and was never intended for A2K or
higher as Conditional Formatting is now directly supported.
See:
http://www.lebans.com/conditionalformatting.htm
New Feb 08,2002. Added support for Datasheet view and SubForms.

A2KConditionalFormatting.zip is a sample MDB demonstrating how to
programmatically setup Conditional Formatting to simulate:

1) Highlighting of the Current Row for a Form in Continuous or Datasheet
View

2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet
View

Version 2.7

Added sample demonstrating how to achieve a background
Hover/Highlighting of rows for a form in Continuous view.

Version 2.3

Added sample demonstrating how to achieve pseudo enable/disable of an
unbound control on a form in Continuous View.

Version 1.9

Added sample form to show how to apply conditional formatting to based
on a Boolean(Yes/No) field.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Steve K" <sk*****@gmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
Firstly, how the heck does this guy do it? Writing reams of (awesome)
code, debugging, responding to Newsgroups etc., all while commanding
the ridiculous price of FREE?!?!?! More power to him!

I'm hoping to use the Highlight Current Row functionality from the
FormatbyCriteriaSubClass database. My problem is that the highlight is
not scrolling. Selection rows works like a charm but the highlight
doesn't move when I scroll.

I am using Access 2003 on an XP machine. I have tried using the
database as is and also converting it to various other versions - no
go. I am prone to breaking things but I get this problem right out of
the box (zip file) without any modifications.

Oh yeah, why on earth has MS not implemented this functionality? Among
the 40,000 other gripes, this is surely one of the more common.

Thanks.


Nov 13 '05 #2
Thanks! you rock!

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Mason | last post: by
1 post views Thread by ChrisR | last post: by
9 posts views Thread by Devron Blatchford | last post: by
5 posts views Thread by Tim Marshall | last post: by
2 posts views Thread by Number 11950 - GPEMC! Replace number with 11950 | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.