Prev: which one is form name
Next: buying access
From: zyus on 26 Apr 2010 22:24
I have a text box that calculate the difference between [text1]-[text2].

How to set a different color if the result is negative.

Thanks
From: John W. Vinson on 26 Apr 2010 22:29
On Mon, 26 Apr 2010 19:24:01 -0700, zyus <zyus(a)discussions.microsoft.com>
wrote:

>I have a text box that calculate the difference between [text1]-[text2].
>
>How to set a different color if the result is negative.
>
>Thanks

Open the report in design view; select this textbox; select Format...
Conditional Formatting from the menu. It's pretty selfexplanatory.
--

John W. Vinson [MVP]
From: Duane Hookom on 26 Apr 2010 22:38
You can also simply set the Format Property. Check Help to find something
like
Format: $#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
This expression sets the format to currency with positive values in Green
and negative values in Red.

--
Duane Hookom
MS Access MVP


"zyus" <zyus(a)discussions.microsoft.com> wrote in message
news:E68D5E67-A90F-4794-B04E-0F7AE647FBB3(a)microsoft.com...
> I have a text box that calculate the difference between [text1]-[text2].
>
> How to set a different color if the result is negative.
>
> Thanks

 | 
Pages: 1
Prev: which one is form name
Next: buying access