Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Forms: Colors and Continuous forms

Author(s)
Dev Ashish

    In a continuous form,  Access has just one set of control properties for all the records displayed.  This means that changes to any control's property will affect all records.

    But you probably already knew that if you were trying to either highlight a particular record from code, or setting the Backcolor of a textbox based on some criteria.

    While the above is true and cannot be changed,  you can use the Format property (search Access Help on those keywords) to conditionally change the color of a textbox.

    Luckily, while cleaning one of my hard drives,  I found a database that I had downloaded off the 'net many moons ago.  Unfortunately,  I don't have the URL or the name of its creator, so I cannot properly acknowledge the individual.  However, if the creator who installed Access with the Name of "University Facilities" and company "Youngstown State University" ever come across this page,  please drop me an email!!

    A sample database is worth more than what I can describe here.  So here you go....

Download Download for Access 97 Download Download ColorCon.zip (from Kevin Gray)

© 1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer