condtional formatting 1

[integritycare]

Hi all,
Just a request for some help with a conditional format of a currency text box.

What is required is that when a currency value in the textbox becomes a negative quanity that the text will indicate that the user has overallocated funds.(probably I would use red txt in the formatting).

Many thanks,
Integrity

 

[dhookom]

You don't need conditional formatting to do this with numeric fields. Just set the Format Property to something like:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"

Duane
Hook'D on Access
MS Access MVP