Alternating Lines using colors

[Guest]

1. Materials: FormA (Form View), SubformB (Datasheet View)
2. Situation: FormA has SubformB
3. Question: How do I code the SubformB (Datasheet View) so that it has
alternating colors on each record.

Thank you in advance for taking the time out to help out.

JMJ

 

[Brian]

1. Materials: FormA (Form View), SubformB (Datasheet View)
2. Situation: FormA has SubformB
3. Question: How do I code the SubformB (Datasheet View) so that it has
alternating colors on each record.

Thank you in advance for taking the time out to help out.

JMJ

Completely impossible in datasheet view. Stephen Lebans has this for
continuous forms:

http://www.lebans.com/alternatecolordetailsection.htm

I've never tried it.

 

[Guest]

Thank you.

Completely impossible in datasheet view. Stephen Lebans has this for
continuous forms:

http://www.lebans.com/alternatecolordetailsection.htm

I've never tried it.

 

[Tom]

Jose

Take a look at:
www.codewidgets.com/product.aspx?key=146

Tom

 

[Stephen Lebans]

Brian with A2K or later you can use ConditionalFormatting to achive
alternating colors for the rows in Datasheet view.
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.

 

[Brian]

Brian with A2K or later you can use ConditionalFormatting to achive
alternating colors for the rows in Datasheet view.
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.

You live and learn! It never occurred to me that conditional formatting
would work in datasheet view (I generally use continuous forms rather than
datasheet). Thanks!