if statements...

L

Little pete

I am wanting to create a number of 'if statements' in my details section of a
report to change the colour of individual cells. Where could I locate some
simple code, including colour numbers

Cheers
 
R

Roger Carlson

On my website (www.rogersaccesslibrary.com), there is a small Access sample
database called "Greenbar2k.mdb", which demonstrates how to make a green and
white altenating report. This may not be exactly that you are looking to
do, but it *does* illustrate changing control background colors in the
Detail section of a report.

As for the color numbers: the easiest way to find them is go to the Design
View of a report or form and select a control and go to the Background
property. Use the Builder button to select a predefined color or create
your own custom color. When you click OK, the actual number will be
displayed in the property.

--
--Roger Carlson
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top