Alternating line colors in Datasheet View

  • Thread starter Thread starter Burt Rosner
  • Start date Start date
B

Burt Rosner

To Anyone that can advise me,

I would like to alternate line colors in a Datasheet view
of a table. Specifically, have one line light yellow, the
next white, then light yellow again.

Is there a way of doing this.

Thanks for any advise, or direction you could give me.

Burt
 
Hi Doug,
that solution is only for forms in Continuous view. Since the OP is
using Datasheet view they need to see:
http://www.lebans.com/conditionalformatting.htm
A2K or Higher Only!

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.
 
-----Original Message-----
Hi Doug,
that solution is only for forms in Continuous view. Since the OP is
using Datasheet view they need to see:
http://www.lebans.com/conditionalformatting.htm
A2K or Higher Only!

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.




.
Stephen,
Click to expand...

Thanks. I was looking at it and it would not have been a
problem to use Continuose Form except I do need the other
properties of Datasheet.

I'm going to look at your suggestion now.

Thanks again,

Burt
 
Back
Top