Prev: Variable number of entries per field in contact report
Next: Using Access 2003 convert numeric month to text for reports
From: Felicia on 20 Jan 2010 11:25
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?
From: Duane Hookom on 20 Jan 2010 17:51
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.

--
Duane Hookom
Microsoft Access MVP


"Felicia" wrote:

> 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?
 | 
Pages: 1
Prev: Variable number of entries per field in contact report
Next: Using Access 2003 convert numeric month to text for reports