I have a form with two fields that I would like to confirm that the values
are equal.
First field requires basic information about an invoice:
fld_Amount
Then I enter the billing information (the accounts I will charge) and that
sum's to a field:
frm_BillingTotal
I want frm_BillingTotal to maintain a white background (the default) if it =
fld_Amount; however, if frm_BillingTotal does not equal fld_Amount, then I
want frm_BillingTotal to turn red (or something that will call attention)
How can I do that???
Thanks
Schmidtnikov - 22 May 2007 18:31 GMT
nevermind.....I should have read more about conditional formatting before
posting.
> I have a form with two fields that I would like to confirm that the values
> are equal.
[quoted text clipped - 15 lines]
>
> Thanks
Marshall Barton - 22 May 2007 18:35 GMT
>I have a form with two fields that I would like to confirm that the values
>are equal.
[quoted text clipped - 11 lines]
>fld_Amount; however, if frm_BillingTotal does not equal fld_Amount, then I
>want frm_BillingTotal to turn red (or something that will call attention)
Use Conditional Formatting on the BillingTotal text box.
Select the Expression Is option:
[fld_Amount] <> [frm_BillingTotal]
and select the desired BackColor.

Signature
Marsh
MVP [MS Access]