Solved

How to 'Cross Out" text in a text box if the used clicks a check box?

Posted on 2014-11-03
2
226 Views
Last Modified: 2014-11-04
I am trying to "cross out" text on a report if the user click the check box called "No".

I can't find anything on the net that does this.

Any help is appreciated
0
Comment
Question by:cssc1
2 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 250 total points
ID: 40420542
You would need to change the font.  A better Access solution would be to "gray" out the box by setting both the enabled and locked properties to false. Or by changing the foreground or background color.  You will need code in the Current event of the form to "mark" existing records as you scroll to them as well as code in the AfterUpdate event of the checkbox to toggle the settings.
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 40420661
You could use a RichTextBox to do this, but it'd be complicated in the extreme, and not very user friendly. Access isn't really a word processor so doing things like this is difficult (at best).

Pat's suggestions would be the way to go - just disable the control.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

895 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

14 Experts available now in Live!

Get 1:1 Help Now