different color for odd rows and even rows

S

sam

different color for odd rows and even rows

Is this possible with Access

If so how.

TIA

sam
 
A

Arvin Meyer

sam said:
different color for odd rows and even rows

Is this possible with Access
Click to expand...

For reports:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Section(0).BackColor = 16777215 Then 'If white
Me.Section(0).BackColor = &HDFDFDF
Else
Me.Section(0).BackColor = 16777215 'else white
End If
End Sub

For forms, see Stephen Lebans website:

http://www.lebans.com/conditionalformatting.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

(headers & footers Issue) I have 2 even pages back to back!! 1
Dealing with a Pivot Table (when I don't want to) 0
Word for Android background colors? (corrected) 0
Unaligned Headers 1
Match table shading (color) to Visio color/Transparency 1
Need Help with a VBA subroutine 0
Integrating information from Word to Excel (not mail merge) 1
Book formatting: need to alternate page number on left and right margin for only first page of each 2

Top