How to create a report border that changes color w/each new secti

F

Felicia

I want to create a report in Access that has a border color change each time
the section changes.

For example:
Green border for all Learning courses
Red border for all Technical courses, etc.

Any suggestions?
 
D

Duane Hookom

The first step is to add a field to your table of courses to store the color.
Then add some code in the On Format event of your report section to change
the border color of a control.
 

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

Similar Threads

Change the color of only one side of a border 1
Automatically change border with changing paper size 2
default border color 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
how do i put a border round a report i created in design veiw? 3
How to create a static Border in a report 1
Ajax error when using response.write() 7
Create new border style? 6

Top