Microsoft KB Archive/302705

= ACC97: How to Base the Background Color of a Text Box on a Value in a Report at Run Time =

Article ID: 302705

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q302705



Moderate: Requires basic macro, coding, and interoperability skills.



SUMMARY
This article explains how to base the background color of a text box on a value that is determined by a report at run time.

This article assumes that you are familiar with Microsoft Visual Basic for Applications and with the programming tools that are provided with Access for creating Access applications. For more information about Visual Basic for Applications, please refer to your version of the Building Applications with Microsoft Access manual.



MORE INFORMATION
To format the background color of a text box so that the color is based on a value, use the OnFormat event:  Right-click the text box, click Properties, and make sure that Back Style is set to either Normal or Solid.  Format the text box by using the OnFormat event of the section where the text box appears. The following example of code shows you how to modify the background color. Replace the field names, variables, and color codes with your own data as necessary. If Me!DateField > #1/1/97# And Me!DateField < #12/31/97# Then Me!DateField.BackColor = 255 'sets text box background to red Else Me!DateField.BackColor = 16777215 'sets text box background to white End If                   

Later versions of Access, both Access 2000 and Access 2002, provide for conditional formatting of text boxes and other controls on forms and reports.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

