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

  • Thread starter Thread starter Arlindo Fragoso
  • Start date 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
 
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?
 
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
 
Hi Fred and Sam

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

Thank you all guys!
Best regards,
AF
 
Back
Top