Alternate color by record (1 Viewer)

jjake

Registered User.
Local time
Today, 11:31
Joined
Oct 8, 2015
Messages
291
Hello,

On my report i am using alternating colors. Some of my records can have a lot of text in them where they carry over to another page. i notice that when a new page starts the same record picks up the alternating color on this new page.

How would i keep each record color specific?
 

isladogs

MVP / VIP
Local time
Today, 16:31
Joined
Jan 14, 2017
Messages
18,186
Don't know but I expect it mightbe complicated

Wouldn't it be better to not split your record over 2 pages?
To do so. set Keep Together=Yes for your detail section in the Property sheet
 

Minty

AWF VIP
Local time
Today, 16:31
Joined
Jul 26, 2013
Messages
10,354
If you have something that will identify the record as "odd or even" / "Colour1 or Colour2" , you can use conditional formatting or the OnFormat property instead of the inbuilt alternative colouring.

As Colin said - it will probably require some VBA.
 

jjake

Registered User.
Local time
Today, 11:31
Joined
Oct 8, 2015
Messages
291
Don't know but I expect it mightbe complicated

Wouldn't it be better to not split your record over 2 pages?
To do so. set Keep Together=Yes for your detail section in the Property sheet

I tried this but it didn't work. Sometimes my records can be over 1 page long.
 

isladogs

MVP / VIP
Local time
Today, 16:31
Joined
Jan 14, 2017
Messages
18,186
Try what Minty suggested which is how people used to do alternate row colouring before it was added to Access..

OR I would just probably remove the alternate colouring.
You could then separate each record with a horizontal line if you wish
 

Users who are viewing this thread

Top Bottom