Shading Alternative Records

[AmberO]

How can I shade alternative records on a continous form?

record 1 background is white
record 2 background is blue
record 3 background is white ..etc

Thanks in advance for help and ideas.....

 

[KyleS]

You could put some code on the "OnCurrent" event of the form...

Dim CurRec as Integer
CurRec = Me.CurrentRecord
If CurRec Mod 2 = 0 Then
Me.Detail.Backcolor = vbBlue
Else
Me.Detail.Backcolor = vbWhite
End If

 

[AmberO]

Thank you for the reply - unfortunately it made the background go white for all records until I select the second record and then the background goes blue for all records and so on.

How can I make the page stripey like the replies in this forum? (Sorry, I'm not very good at programming just yet!)

Amber

 

[KyleS]

Amber, what version of Access are you using? I know Access 2000 has built-in conditional formating, but I only have '97 here at work, so Ican't tell you how to use it, but maybe that's a direction to go. I've tried to come up with something here in '97, but have had no luck...

Maybe one of our colleagues has an example...?

Sorry I've been of no help, (I missed the "continuous form" part of the original post) I'll keep trying and if I come up with some thing I'll post it right away.

Kyle

 

[AmberO]

Hi Kyle,

I'm using access 2000 - I'll look up conditional formating.

Thanks so much for trying to help me!

Amber

 

[snoopy75]

As far as I know, there is currently no way to format individual records on a continuous form. Any formatting is applied to all records.

However, if you can somehow use a list box instead, you can use a callback function to do individual formatting of list items...

 

[crose7227]

If totalrecords = False Then
Detail.BackColor = 16777215
totalrecords = True
Else
totalrecords = False
Detail.BackColor = 12632256
End If

land of milk and Honey

 

[crose7227]

whoops forgot the explanation

make a boolean type variable and name it totalrecords (or replace the code above with you custom variable)

this one above makes a nice grey and white alternating record count...

easy on the eyes and professional looking land of milk and Honey

 

[K9Boxer]

Where is this code placed? Thanx

 

[crose7227]

in the Detail Format event land of milk and Honey

 

[crose7227]

ooops that is for a report....

you want it for a form...

let me check land of milk and Honey