Conditional formatting with VB

[Bresart]

Hi, i have included the code at

http://msdn2.microsoft.com/en-us/library/aa139965(office.10).aspx

for making conditional formatting from code (i need a forecolor not included in the dialog box palette).

It hasn't worked for Access 2000. Any other option?

Thanks for any help given.

 

[genomon]

Wow. Long article. Without knowing exactly what "hasn't worked", and assuming all you want to do is change the fore color, all you need to do is set the fore color property to a long integer that corresponds to the color you want. The best way to find the magic number in this case is probably trial and error. Good luck!

When everything is coming your way, you're in the wrong lane.

 

[GingerR]

What's your code? What's not working?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Bresart]

I localized where the error was. Thanks genomon GingerR.