By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

Lebans Highlight Selected Row

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
Thanks! you rock!

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.