Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / September 2007

Tip: Looking for answers? Try searching our database.

Continuous forms, change color for each record

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joe Coulter - 22 Nov 2006 13:55 GMT
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 - 22 Nov 2006 16:29 GMT
Here's one way:
http://www.lebans.com/alternatecolordetailsection.htm

>Hi
>
[quoted text clipped - 6 lines]
>
>Joe

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Joe Coulter - 23 Nov 2006 07:56 GMT
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
ruralguy - 23 Nov 2006 15:11 GMT
Mr. Lebans does not disappoint! Thanks for posting back.

>Thanks RG
>
[quoted text clipped - 8 lines]
>> >
>> >Joe

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Devon - 10 May 2007 14:49 GMT
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.
>
[quoted text clipped - 10 lines]
> >> >
> >> >Joe
Devon - 06 Sep 2007 12:56 GMT
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.  
[quoted text clipped - 18 lines]
> > >> >
> > >> >Joe
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.