Conditional Formating in Access 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone, is Conditional Formating possible in Access 97 Reports. I
have a few reports and I would like to highlight values that are less or
equal to 0. Please help, thanks.
 
A97 does not have the conditional formatting feature that was introduced in
A2000.

However, you can set the Format property of a text box so that it shows
negative and/or zero numbers differently. Example:
$#,##0.##[black];-$#,##0.##[red];
 
This is great, instead of formating the text, how can I change the background
of the text box as the conditional format?

Allen Browne said:
A97 does not have the conditional formatting feature that was introduced in
A2000.

However, you can set the Format property of a text box so that it shows
negative and/or zero numbers differently. Example:
$#,##0.##[black];-$#,##0.##[red];

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.
JavyD said:
Hello everyone, is Conditional Formating possible in Access 97 Reports. I
have a few reports and I would like to highlight values that are less or
equal to 0. Please help, thanks.
Click to expand...
Click to expand...
 
JavyD said:
Thanks roger, bu this is for a form, I have a report.
Click to expand...

Reports are even easier. Just use code in the format event of the
appropriate section to change whatever properties you want.
 
Then all you need is a simple If statement in the On Format event of your
Detail Section, very much like the Single Form example on the sample
database I mentioned. Something like this:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtBal < 0 Then
Me.txtBal.BackColor = vbRed
End If
End Sub

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Use code like Roger gave you.

You may need an "Else" in the If block, to change it back if the condition
is not met.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

JavyD said:
This is great, instead of formating the text, how can I change the
background
of the text box as the conditional format?

Allen Browne said:
A97 does not have the conditional formatting feature that was introduced
in
A2000.

However, you can set the Format property of a text box so that it shows
negative and/or zero numbers differently. Example:
$#,##0.##[black];-$#,##0.##[red];

JavyD said:
Hello everyone, is Conditional Formating possible in Access 97 Reports.
I
have a few reports and I would like to highlight values that are less
or
equal to 0. Please help, thanks.
Click to expand...
Click to expand...
Click to expand...
 
Good catch on the "Else", Allen. I should have thought of that. <grimace>

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Allen Browne said:
Use code like Roger gave you.

You may need an "Else" in the If block, to change it back if the condition
is not met.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

JavyD said:
This is great, instead of formating the text, how can I change the
background
of the text box as the conditional format?

Allen Browne said:
A97 does not have the conditional formatting feature that was introduced
in
A2000.

However, you can set the Format property of a text box so that it shows
negative and/or zero numbers differently. Example:
$#,##0.##[black];-$#,##0.##[red];

Hello everyone, is Conditional Formating possible in Access 97 Reports.
I
have a few reports and I would like to highlight values that are less
or
equal to 0. Please help, thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top