From the post origination:
barry2004 said:
[blue]Are there ways of changing the colours of all the rows whose ID numbers are either Odd or even? E.g. rows with record ID's 1,3,5,7,9,11 etc.[/blue]
Bear in mind, conditional formatting can only control [blue]comboboxes[/blue] and [blue]textboxes[/blue]. Also, as shown by [blue]
RoyVidar's[/blue] link, be careful of [blue]calculated controls[/blue] included in your format condition.
Copy the following expression:
Code:
[blue][YourIDFieldName] Mod 2 <> 0[/blue]
Open the form in designview.
Then for each textbox/combobox you wish to change color in a record for odd IDs:
[ol][li][blue]Select[/blue] the control.[/li]
[li]MenuBar - Format - [blue]Conditional Formatting...[/blue][/li]
[li]In the combobox select [blue]Expression Is[/blue][/li]
[li]In the field next to the combobox [blue]paste the expression.[/blue][/li]
[li]Select the [blue]background/foreground[/blue] colors you desire & click ok.[/li][/ol]
[blue]
RoyVidars[/blue] has also provided a good method for coloring a complete section.
[purple]Cheers! . . .[/purple]
See Ya! . . . . . .