Continuous forms, change color for each record

[Guest]

Hi

I have a sub form which is continuous, this works fine except as more than
one record can be seen at the same time, it looks quite busy, I would like
every other record to be one colour and the records in between these to be
another color, how can I format the continuous form to do this?

Thanks in advance

Joe

 

[ruralguy via AccessMonster.com]

Here's one way:
http://www.lebans.com/alternatecolordetailsection.htm

 

[Guest]

Thanks RG

That method worked just fine, I just copied all the code and modified it for
my use, it works like a treat, also I got a lot more than I asked as the
method also allows me to change the color and turn on and off the colors as I
wish.

 

[ruralguy via AccessMonster.com]

Mr. Lebans does not disappoint! Thanks for posting back.

Thanks RG

That method worked just fine, I just copied all the code and modified it for
my use, it works like a treat, also I got a lot more than I asked as the
method also allows me to change the color and turn on and off the colors as I
wish.

Here's one way:
http://www.lebans.com/alternatecolordetailsection.htm

[quoted text clipped - 9 lines]

 

[Guest]

I tried your source code for this function and it works great.....except when
my form opens the window position is in the upper left rather than centered.
What and where do I change the code so that the form keeps a center position
and size?

Thanks,
Devon

Mr. Lebans does not disappoint! Thanks for posting back.

Thanks RG

That method worked just fine, I just copied all the code and modified it for
my use, it works like a treat, also I got a lot more than I asked as the
method also allows me to change the color and turn on and off the colors as I
wish.

Here's one way:
http://www.lebans.com/alternatecolordetailsection.htm

[quoted text clipped - 9 lines]

Joe

 

[Guest]

Never mind! I found the solution.

I tried your source code for this function and it works great.....except when
my form opens the window position is in the upper left rather than centered.
What and where do I change the code so that the form keeps a center position
and size?

Thanks,
Devon

Mr. Lebans does not disappoint! Thanks for posting back.

Thanks RG

That method worked just fine, I just copied all the code and modified it for
my use, it works like a treat, also I got a lot more than I asked as the
method also allows me to change the color and turn on and off the colors as I
wish.

Here's one way:
http://www.lebans.com/alternatecolordetailsection.htm
[quoted text clipped - 9 lines]

Joe