X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Closed TopicStart new topic
> Create a Subform with Alternating Color Rows    
post Feb 27 2006, 10:14 PM

Posts: 296
Joined: 27-February 06
From: Long Beach CA

Title: Create a Subform with Alternating Color Rows
Symptom: Unlike Reports, Access does not provide an easy method for providing alternate color rows in forms.
Subject: This tutorial provides a step-by-step approach in designing underlying queries to allow the form to display alternate rows using the Conditional Format function.
Applies to: Access 2000 and up Tested in: Access 2000, Access 2003
Skill level: Intermediate
Author: Michael Reese, ZapDude Software Date: 2/27/06
Credits: Microsoft Office Help (Conditional Formatting function)
Keywords: Forms, subforms, running count, query
Overview: Access reports have the ability to have many formatting functions applied, such as formatting that can be provided through the Detail Method. Access forms are limited in their scope. However, the Conditional Formatting Function, available from Access 2000 on, provides the key to providing the formatting that uses query calculations to alternate the color of data rows.
Discussion: This method does NOT make use of VBA code! Instead, it instructs the user how to create the underlying querysets to provide the calculations that allow the Conditional Formatting Function to display data in alternating color rows.
Code: None (Except for providing sample forms / subforms)
Attached File(s)
Attached File  AccessTutorial07.zip ( 234.92K )Number of downloads: 2604
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    4th July 2020 - 12:40 AM