When I saw some netizens ask this question, I felt a little confused about the answer. So I wrote this article and hoped it would be helpful to some netizens!
The procedure is as follows:
1. Right-click the title axis of the detail section, select "format section", and open "section expert ";
2. Click the "color" tab and select the "background color" check box ";
3. Here, we use the report field "brand" as the color setting condition to bring up the Default background color first. Select "Custom" from the drop-down list
In the "color" dialog box, specify the color you want. I use RGB (200,171,162) and click "add
Click "custom color", select the custom color, and then click "OK;
4. Press the formula button and write the following Conditional Formatting formula (basic syntax) in the format editor dialog box ):
Select case ({myaccess. Brand })
Case "Spirit"
Formula = RGB (1, 244,126,254)
Case "Quattro"
Formula = RGB (1, 142,142,255)
Case "JVC"
Formula = crlime
Case else
Formula = defaultattribute
End select
5. Save the formula and close the format editor dialog box;
6. Click "OK" in "expert section.
7. The final effect is as follows:
From: http://blog.csdn.net/xwdd129/archive/2005/01/21/262609.aspx