conditional formatting in a Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WBTKbeezy - 31 Oct 2005 16:42 GMT

I am using a database to track changes in 2 tables via a report. The report
shows the original table and the edited table side by side, but I would like
to highlight the fields if they have changed. (i.e., if Textbox1 <>Textbox 2,
highlight) I tried using Conditional formatting in TextBox1 to read -->
Field Value Is, Not Equal To, [Textbox2] But when I go to view the report a
box pops up prompting me to enter a value for Textbox 2... any help??

Reply to this Message

Ofer - 31 Oct 2005 17:16 GMT

In the conditional formating try and use the name of the field in the table,
and not the name of the field in the report

Signature

If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

> I am using a database to track changes in 2 tables via a report. The report
> shows the original table and the edited table side by side, but I would like
> to highlight the fields if they have changed. (i.e., if Textbox1 <>Textbox 2,
> highlight) I tried using Conditional formatting in TextBox1 to read -->
> Field Value Is, Not Equal To, [Textbox2] But when I go to view the report a
> box pops up prompting me to enter a value for Textbox 2... any help??

Reply to this Message