How to change the font color on a report basead in a criteria?

  • Thread starter Arlindo Fragoso
  • Start date
A

Arlindo Fragoso

Hi!

I would like how to change the font color on a field of the report basead in a criteria of a certain text value.
Any ideia how to do it?

TIA
Arlindo Fragoso
 
F

fredg

Hi!

I would like how to change the font color on a field of the report basead in a criteria of a certain text value.
Any ideia how to do it?

TIA
Arlindo Fragoso
Click to expand...

It depends.
Which version of Access?
 
S

Sam D

Use the Detail_Format event to alter the ForeColor property of the text
box...

For example if you wanted the text box called CName to be RED when say CName
is less than "mark" and BLACK at other times then something like...

If Cname < "mark" Then
Cname.ForeColor = vbRed
Else
Cname.ForeColor = vbBlack
End If

HTH
Sam

Hi!

I would like how to change the font color on a field of the report basead in
a criteria of a certain text value.
Any ideia how to do it?

TIA
Arlindo Fragoso
 
A

Arlindo Fragoso

Hi Fred and Sam

I use Access 2000 and the code Sam sugested it's working!

Thank you all guys!
Best regards,
AF
 

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

Need help modifying code 0
Outlook 365 overriding formatting choices 0
How can the font and size of (all) citation numbers be altered? 1
report convert to sanpshot or word document color 0
Start a mail merge upon opening the document 1
Access 2002 change report header text 0
Problem with MS Word paragraph and character styles: format getting messed up 2
How to modify and updte specific styles for specific paragraphs across the document 0

Top