Print Page | Close Window

ChangingColorFields.mdb (Access 97 Only)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=387
Printed Date: 25 Sep 2020 at 3:09am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: ChangingColorFields.mdb (Access 97 Only)
Posted By: Roger Carlson
Subject: ChangingColorFields.mdb (Access 97 Only)
Date Posted: 03 Aug 2008 at 10:56pm

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .

ChangingColorFields.mdb

This sample illustrates how to change the color of a control on a form based on information in the form. In this case, if Check 14 checkbox is checked, then the values of Desc will be red, otherwise it will be blue. You can also check for values in text boxes. For instance, if JanBal <500 it could be blue, other wise red.

A second form shows how to change the background color of a text control in a continous form, based on a value in each record.

For higher versions (Access 2000+) see my sample  http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=375 - ConditionalFormatting.mdb .
 
Download
Access 97 (46 KB):
http://rogersaccesslibrary.com/download3.asp?SampleName=ChangingColorFields.mdb - ChangingColorFields97.zip


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net