Conditional Formatting: Basic Help 1

[XMalvolio]

I'm pretty new to Access, and I've gotten far, but conditional formatting is too far beyond me.

I have a field [Customer] in a table [JobData] that I want to turn Bold if the field [BioCompany] is = "BC". The BioCompany field is not displayed on the report, but is in the JobData table.

Thanks!
Steve

 

[THWatson]

Steve
What you could do is put the BioCompany field on the report but make it invisible. Then use Conditional Formatting (from the Format tab), and use an Expression. In the Expression box put...
[BioCompany] = "BC" and then click the Bold icon.

Have a look at this Microsoft link if you would like to read something further..

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_conformat.asp

Tom

 

[XMalvolio]

Fantastic thank you that's perfect. I wish the Conditional Formatting box had an expression builder link in it!

 

[THWatson]

Steve
Glad it worked.

Tom