Conditional Formatting Problems

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello I have had a look at that conditional Formatting
Page of Stephen Lebans site. I cannot find out though how
to get Access to recognise that my record is Odd or Even..

Once I have done that I would need to apply conditional
Formatting to it...

Could someone please assist in taking me through what I
would need to do for this please as I have not done it
before...

Many Thanks

James
 
It depends whether you form will be viewed Continuous or Datasheet view.
I'll assume Datsheet view.

Look at the code behind the sample form named
"CustomerInDatasheetViewAlternateRows".

You will have to duplicate this code behind your own form. THe only
modification would be for you to specify the class's KeyFieldControl
propertywith that of whichever TextBox control on your form is bound to
a field that is used to Index the recordsource.

Finally, the sample code behind the form set's the class's
HighlightColor to vbRed. Modify this to yhe color value of your choice.

That's it. My CF class does the rest.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top