Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2014-11-03
2
231 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 35

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

808 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