Solved

access conditionally format textbox via checkbox

Posted on 2011-02-18
3
348 Views
Last Modified: 2012-06-27
Forgotten how to do this.

Just want to conditionally format textbox text to turn from black to red when adjacent checkbox is ticked.

Expression? what to put in conditional formatting controls ?
0
Comment
Question by:topUKlawyer
3 Comments
 
LVL 51

Accepted Solution

by:
HainKurt earned 250 total points
ID: 34927021
check this from ms

Change the appearance of a control by using conditional formatting

http://office.microsoft.com/en-us/access-help/change-the-appearance-of-a-control-by-using-conditional-formatting-HA010208133.aspx
0
 
LVL 119

Assisted Solution

by:Rey Obrero
Rey Obrero earned 250 total points
ID: 34927067
select the textbox, then click on Format > conditional Formatting

place this codes

expression is   [checkBoxName]=-1

set the text color to red
0
 

Author Closing Comment

by:topUKlawyer
ID: 34927503
both very helpful
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now