Fonts Color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alimbilo - 15 May 2008 21:10 GMT

Hello,
How can I have a font to change color for example if the answer is negative,
I want it to be in RED and if it's positive BLACK.

Thanks

Reply to this Message

Douglas J. Steele - 15 May 2008 22:27 GMT

Look into Conditional Formatting.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hello,
> How can I have a font to change color for example if the answer is
> negative,
> I want it to be in RED and if it's positive BLACK.
>
> Thanks

Reply to this Message

John Spencer - 20 May 2008 12:14 GMT

IF this is on a report, you can use the format property of the control.

Just set the format to something like the following.
#,##0.00[Black];-#.##0.00[Red];0[Green]

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

> Look into Conditional Formatting.

Reply to this Message

Margaret Bartley - 20 May 2008 02:39 GMT

If this is a report, in the BeforeFormat option of the Detail section,
put
If Answer <0 then
Answer.FontColor=255
Else
Answer.FontColor=0
End If

> Hello,
> How can I have a font to change color for example if the answer is
> negative,
> I want it to be in RED and if it's positive BLACK.
>
> Thanks

Reply to this Message

Linq Adams - 20 May 2008 04:15 GMT

I'm familiar with the Detail_Format event of the Detail section of a report,
but what version of Access do you find the BeforeFormat event in?

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message