R
Robb @ FLW
In my report I have that has yes or no entries how do I make only the no
entries change the font to red so that they will stand out
entries change the font to red so that they will stand out
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Use conditional formatting on that control. It is in the "Format" menu.
F
fredg
In my report I have that has yes or no entries how do I make only the no
entries change the font to red so that they will stand out
What is the field's datatype? Text? Boolean?
What version of Access?
Can only give generic information with out more info from you.
If [SomeControl] is Text datatype, code the report's Detail Format
event (if the control is in the detail section:
If [SomeControl] = "No" then
[SomeControl].ForeColor = vbRed
Else
[SomeControl].ForeColor = vbBlack
End If
You can also use the control's Format property or Conditional
Formatting property, depending upon datatype and Access version.
R
Robb @ FLW
I have tried that and it dosen't turn the "No" entries to red
R
Rick B
If you have tried it, you should tell us that when you post. What did you
try? What entries did you make?
try? What entries did you make?
R
Robb @ FLW
Sorry about that, I have selected my control, I right clicked on it and
selected Conditional Formating and I have the following chosen
1st box is. Field value is
2nd box is. equal to
3rd box is. No
and I have selected the color red to be the color.
does this help?
selected Conditional Formating and I have the following chosen
1st box is. Field value is
2nd box is. equal to
3rd box is. No
and I have selected the color red to be the color.
does this help?
F
fredg
Sorry about that, I have selected my control, I right clicked on it and
selected Conditional Formating and I have the following chosen
1st box is. Field value is
2nd box is. equal to
3rd box is. No
and I have selected the color red to be the color.
does this help?
Part of the problem is that you really haven't been forthcoming with
enough information to have us help you properly.
What is the field's datatype? Is It Text?
Then you need to set the Field Value to "No" (within quotes).
If the field is a Yes/No field (i.e. check box), then you cannot
change the check box color, but you can change it's label color using
code (which I gave you in my other reply).
If the control is a Text control bound to a Yes/No field, then you can
use the control's Format property:
;"Yes" [Black];"No" [Red];
F
fredg
I meant to add if you use code, that if the field is a Number datatypePart of the problem is that you really haven't been forthcoming with
enough information to have us help you properly.
What is the field's datatype? Is It Text?
Then you need to set the Field Value to "No" (within quotes).
If the field is a Yes/No field (i.e. check box), then you cannot
change the check box color, but you can change it's label color using
code (which I gave you in my other reply).
field, you write the criteria like this:
If [SomeControl] = No then .. etc .. (without the quotes).
If the control is a Text control bound to a Yes/No field, then you can
use the control's Format property:
;"Yes" [Black];"No" [Red];