H
Hanksor
Is it possible to change the background color of a report textbox depending
on the value of the field value? Any help will be appreciated.
on the value of the field value? Any help will be appreciated.
Is it possible to change the background color of a report textbox depending
on the value of the field value? Any help will be appreciated.
Chris Reveille said:All versions can use the Format event of the report section
to change the backcolor, forecolor, etc. when the report is
run.
If [AField]>0 Then
[AField].BackColor = vbBlue
[AField].ForeColor = vbYellow
Else
[AField].BackColor = vbWhite
[AField].ForeColor = vbBlack
End If
Chris
-----Original Message-----
Unfortunately, We are still in the dark ages with 97. Any Ideas?
"Mark" <> wrote in message news:[email protected]...
.
Hanksor said:I've tried this with no results. My field is a text field, could this be
an
issue?
Here is my code;
Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
If [HowBilled] = "mon" Then
[HowBilled].BackColor = vbBlue
Else
[HowBilled].BackColor = vbRed
End If
Hanksor
Chris Reveille said:All versions can use the Format event of the report section
to change the backcolor, forecolor, etc. when the report is
run.
If [AField]>0 Then
[AField].BackColor = vbBlue
[AField].ForeColor = vbYellow
Else
[AField].BackColor = vbWhite
[AField].ForeColor = vbBlack
End If
Chris
-----Original Message-----
Unfortunately, We are still in the dark ages with 97. Any Ideas?
"Mark" <> wrote in message You can use conditional formatting from the "Format" menu while in design
view of the report.
Is it possible to change the background color of a report textbox
depending
on the value of the field value? Any help will be appreciated.
.
-----Original Message-----
I've tried this with no results. My field is a text field, could this be an
issue?
Here is my code;
Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
If [HowBilled] = "mon" Then
[HowBilled].BackColor = vbBlue
Else
[HowBilled].BackColor = vbRed
End If
Hanksor
All versions can use the Format event of the report section
to change the backcolor, forecolor, etc. when the report is
run.
If [AField]>0 Then
[AField].BackColor = vbBlue
[AField].ForeColor = vbYellow
Else
[AField].BackColor = vbWhite
[AField].ForeColor = vbBlack
End If
Chris
-----Original Message-----
Unfortunately, We are still in the dark ages with 97. Any Ideas?
"Mark" <> wrote in message You can use conditional formatting from the "Format" menu while in design
view of the report.
Is it possible to change the background color of a report textbox
depending
on the value of the field value? Any help will be appreciated.
.
.