Alternating Row Colr

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Is there a easy way to alternate the background color property in the detail
section of a report?
 
try the following code, as

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

If Me.Detail.BackColor = 16777215 Then
Me.Detail.BackColor = 16777130
Else
Me.Detail.BackColor = 16777215
End If

End Sub

the above alternates the color from light blue to white; substitute any
colors you want.

hth
 
Scott said:
Is there a easy way to alternate the background color property in the
detail section of a report?
Click to expand...

In the Format event of the detail section...

If Me.Detail.BackColor = vbWhite Then
Me.Detail.BackColor = vbGreen
Else
Me.Detail.BackColor = vbWhite
End If
 
One problem, my text boxes with values have a white background by default.
In order to make the row be white and alternate to a color, do i have to
have the code change their back color also?
 
normally, textbox controls in a *report* have a Transparent backstyle by
default. did you change it to Normal? or are you working with a *form*,
rather than a report?

the code that Rick and i gave you won't work in a form. if you *are* working
in a report, just change all the controls' BackStyle property to
Transparent.

hth
 
it's a report. thanks.


tina said:
normally, textbox controls in a *report* have a Transparent backstyle by
default. did you change it to Normal? or are you working with a *form*,
rather than a report?

the code that Rick and i gave you won't work in a form. if you *are*
working
in a report, just change all the controls' BackStyle property to
Transparent.

hth
Click to expand...
 

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

Progress bar & explanation of code 1
Alternating colors on continuous form 2
Hiding labels on reports 2
Alternate row color for combo box 3
conditional format - table - cell empty return default color 1
Column alignment in listbox & alternating row colors 1
Changing height of text box control as row height changes 1
Sginatures are in Ivory even though Black is the font color 1

Back
Top