Condition Formatting

Hi Stephen, welcome to the forum, Thanks for the post;
To change a field in a report based on its value, you can apply conditional formatting.
To do this, open your Access report and highlight the field that you want to change the behavior of.
In this example, lets consider using a field called Category ID field.
Under the Format menu, select Conditional Formatting.
When the Conditional Formatting window appears, enter the first condition. In our example, lets select when the field value is less than 3.
Next, you need to select what formatting to apply when the condition is met. Let