Continous forms - records displayed in different colours 1

[Moss100]

Is it possible to have say the first record appearing on a white background, the second with say blue, end back to white, etc....

Thank you

Mark

 

[PHV]

Have a look at conditional formatting and the Mod operator.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dhookom]

Or upgrade to Access 2007.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[TheAceMan1]

How are ya Moss100 . . .

Here's a function you can use for your [blue]Conditional Formatting.[/blue] Copy/paste to the [blue]code module[/blue] of the form. Note: you substitute [purple]PKname[/purple] (your primarykey name) proper:

[blue]Public Function flgFmt() As Boolean
   Me.RecordsetClone.FindFirst "[[purple][b][i]PKname[/i][/b][/purple]] =" & Me("[purple][b][i]PKname[/i][/b][/purple]")
   
   If (Me.RecordsetClone.AbsolutePosition + 1) Mod 2 = 0 Then
      flgFmt = True
   End If

End Function[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

 

[Moss100]

As always - thanks you genius chaps