Conditional Formatting expression syntax?

CoderGeek

New member
Local time
Today, 13:31
Joined
Sep 20, 2004
Messages
9
I was wondering if anyone knows the syntax for doing a odds or even type expression in a conditional format. basicly I have a field that has vaules of 100,200,300,400,... up to 900. what I want to do is hilight all the even numbers and leave the uneven white. if someone knows the syntax that would be great. here is what I have so far but it does not work exactly right
[SizeCampagin] / 200
 
Thanks

yeah I just found the Mod operation in the Access help figured I would post how I found it so if someone else had the same problem it would save them some time
 

Users who are viewing this thread

Back
Top Bottom