Alternating line colors in Datasheet View

[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

 

[Douglas J. Steele]

See whether what Stephen Lebans has at
http://www.lebans.com/alternatecolordetailsection.htm helps.

 

[Stephen Lebans]

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.

 

[Douglas J. Steele]

Thanks, Stephen. I can never keep them straight!

 

[Burt Rosner]

Doug,

Thanks,

Burt

-----Original Message-----
See whether what Stephen Lebans has at
http://www.lebans.com/alternatecolordetailsection.htm helps.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






.

 

[Burt Rosner]

-----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,

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