Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

Alternate Subform/Datasheet row colors (MS Access 97 !!!! ) ??

I'm tryng to do something like this : http://www.comriesoftware.net/codewidgets/product.aspx?key=146 but for Access 97 (the article tip is only for Access 2000/ XP).
Any hints?
0
luis_mdb
Asked:
luis_mdb
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Pasting a URL that does not return a 404 'The page cannot be dispayed' error message would help.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Hi jimhorn,

I can browse the link ...

HTH,
LSM Consulting (Scott McDaniel)
0
 
luis_mdbAuthor Commented:
Been hours looking for this online .. post it to E-E .. then 10 minutes later found the solution:
http://www.lebans.com/alternatecolordetailsection.htm
for anyone who might needed.

thanks for your attention
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Got it to go this time.

luis - Thanks for posting the link.  I'll give this a shot myself, as I've been able to do this on reports for awhile now, but not with forms.

-Jim
0
 
jjafferrCommented:
There is another way of doing this too:
make the Record source of your Form a Query,
In the Query make a field that generats Serial number, lets call it Serial1
Now in the SubForm/Datasheet, use conditional Formating, if Int([Serial1])=[Serial1], then you can do your Formating,
but this method applied to each field individually, so you will have to apply the conditioanl formating to all the fields.

jaffer
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
No objections.
0
 
jjafferrCommented:
No objections.
0
 
ee_ai_constructCommented:
Question answered by asker or dialog deemed valuable.
Closed, 250 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now