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

MORE INFORMATION

To format the background color of a text box so that the color is based on a value, use the OnFormat event:

1. Right-click the text box, click Properties, and make sure that Back Style is set to either Normal or Solid.
2. 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.