How do I format a field in a report based upon the results in another field.

[jmtrobough]

Situation is: I have a report that has a field that will be formatted based upon the results in another field. For example if 'Field 2' equals "IBR" 'Field 1' would be formatted with – italics, bold, red font. ‘Field 2’ could equal up to 6 different results changing the font of ‘Field 1’ accordingly. I know this needs to be done by coding but not sure how.

Thank you for the help.

[patjones]

You can use conditional formatting to accomplish this; it won't require you to use code (although it might be possible to use code - but why complicate things?).

Open the report in design view, click on the field that you want to format (Field 1), and in the Conditional Formatting pop up pick Expression Is, then type [Field 2] = "IBR". Select the formatting option appropriately.

Let us know how it works.

Pat

[jmtrobough]

zepphead80

Thanks for the assistance, however this will only work if you have 3 or less conditions. I have at least 6 different conditions.

Thx

[jmtrobough]

Thanks for the assistance, however this will only work if you have 3 or less conditions. I have at least 6 different conditions.

Thx

[patjones]

That's why you use the "Expression Is" option, and then type your criteria into the box next to the drop down - which can be as complicated as need be. This is all done on one line.

Pat

[patjones]

For example, in my test database I have the conditional formatting on the ERN (Employee Reference Number) field set to [DOB] >= #1/1/1970# And [last name] = "JONES". You can use as many other fields and conditions as you want by typing in the expression just under "Condition 1". It isn't necessary to add other lines.

Pat