Thanks for the reply Stephen. I appreciate your patience!
What I was trying to do initially was have a button (that when clicked)
would cycle through multiple preset forecolor and backcolor settings -
in turn changing the alternating rows of the Subform with a new color
scheme (one click at a time until the user found one color scheme he
liked).
I have seen this done in the link below (looking at Colorcon.zip) and I
understand the principle idea of having a long textbox in the
background.
http://www.mvps.org/access/forms/frm0024.htm
It's very complex and I thought there must be an easier way to
accomplish this without all the links to the long textbox, table fields
etc...
Maybe I am trying to do the impossible here but I was trying to use the
fAlternateRowA Function to get the Even/Odd row count and simply change
the alternating row color.
Explanation:
I thought by setting the Conditional Formatting object (Forecolor and
Backcolor properties programatically ) either with a function linked in
the Condition1 'Expression Is' on the CF side would work.
OR
By removing the CF conditions altogether thus causing the Subform rows
to have no color at all when the Subform initially loads AND placing all
the color changing code behind a button click would be easy but I have
found it is quite hard to do.
Behind the button click I am having trouble getting Even/Odd row numbers
for starters so I found myself stuck because I can only get the Even/Odd
row values by placing the fAlternateRowA calls in the CF Conditions
Side.
Maybe I'll take a look at the Colorcon.zip example again and see if I
can find an easier way to do what they did. It's quite crafty.
Anyone who may have tinkered with that example is welcomed here! =]
TIA!!
Wes
Previous Message:
From: Stephen Lebans
Date Posted: 11/17/2003 5:33:00 PM
You cannot modify the FormatCOndition s object from within a function
called by CF. THis means you are limited to a total of 3
colors(conditio ns).
I thought what you wanted to do was simply allow the user to select what
these 3 colors should be. Am I mistaken?
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!