Report : having two differents looks for repeat line

  • Thread starter Thread starter PHil
  • Start date Start date
P

PHil

Hi there,

I have a report with repeating lines

I need to have line 1 with look 1 (say background color to black)
and line2 with look2 (say background color to white)
and line 3 with look 1
and line 4 with look2

and so on

how can I do that in Access 2003 ? with coding or directly in Access ?

Sorry if this is a beginner question :)

Thanks for any help!
 
its me again, i found a code that allows to change the background color of
the concerned part (section in french). I try to adapt it for fields but it
does nothing.
Can somebody help ? Thanks in advance

Here is the non working code

Dim NbLignes As Integer
Private Sub Détail_Format(Cancel As Integer, FormatCount As Integer)


If FormatCount = 1 Then
If NbLignes Mod 2 = 1 Then
Texte33.BackColor = RGB(185, 210, 201)

Else
Texte33.BackColor = RGB(255, 255, 255)

End If
NbLignes = NbLignes + 1

End If


End Sub
 
That code works fine for me. Assuming Texte33 is, in fact, a text box, try
using Me.Texte33.BackColor instead.
 
I tried that but it got no effect ... looks like backColor is not
defined/available for a text box.
 
Is it possible that it's called something else in the French version? As I
said, other than having to change the name of the control, your code worked
fine for me.
 
Back
Top