Report format question

[rynorem]

My employee report is one employee w/info per page. How can I get the whole page to be yellow if, let's say, the guy works for Billing Department. So when I put his employee number in and it brings his record up it will be yellow because he is in Billing. Can I make it so each department has a different color? I can experiment but don't know where to go to begin. Thanks!

 

[alastair69]

Have a look at this link, it maybe of use to you.

http://msdn.microsoft.com/library/d...us/vbaac11/html/acproBackColor_HV05187026.asp

Alastair