Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 302705 - Last Review: January 31, 2007 - Revision: 4.1
ACC97: How to Base the Background Color of a Text Box on a Value in a Report at Run Time
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.
REFERENCES
For more information about using the OnFormat event in reports, search the Help Index for
OnFormat property.
APPLIES TO
- Microsoft Access 97 Standard Edition
| kbhowto kbprogramming kbui KB302705 |
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please