Change font color

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

Guest

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
 
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
Click to expand...

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.
 
If you have tried it, you should tell us that when you post. What did you
try? What entries did you make?
 
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?
 
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?
Click to expand...

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];
 
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).
Click to expand...
I meant to add if you use code, that if the field is a Number datatype
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];
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

Excel Conditional formula for different scenarios 0
Color Font on half a Text Box? 4
Dcount the values 0
Access How to record date/time when specific field is modified in Access 2007 0
VBA to select font/colour not working 1
At last, ‘Murphy’s Law’ contradicted 7
won't print color 1
Word Changing default font color in MS Word (selectively) 0

Back
Top