conditional formating

[2Stupid2ownAputer]

Hi can anyone help with conditional formatting in datasheet view.
Field is ID (primary key) of two parts :- integer part and decimal part e.g
.. 0109.05
Integer part is a group of people and decimal part is an individuals place
in that group
Disregard decimal part INT(ID)
Now when INT(ID) changes which could be odd or even, after a query ie that
particular group
I wish to change the field colour in order to highlight the groups
Something like me!(int(id)).change ???
Thanks friends

 

[fredg]

Hi can anyone help with conditional formatting in datasheet view.
Field is ID (primary key) of two parts :- integer part and decimal part e.g
. 0109.05
Integer part is a group of people and decimal part is an individuals place
in that group
Disregard decimal part INT(ID)
Now when INT(ID) changes which could be odd or even, after a query ie that
particular group
I wish to change the field colour in order to highlight the groups
Something like me!(int(id)).change ???
Thanks friends

If Form Datasheet view?
Not really sure of what you mean, but in try setting the Conditional
Formatting property of the ID control to:

Expression is
Int([ID]) Mod 2 = 0

Set the color for when the condition is met to what ever you want.

Each Even numbered integer color will be changed.

 

[2Stupid2ownAputer]

Hello Fred thanks for replying to my post
Unfortunately that does't solve my problem because there could
more than two even or more than two odd numbers next to each other
102.01
102.02
108.01
108.02
But you have given me in idea -- the different groups all start with xxxx .
01
so I`ll try and utilise that
Best regards