Strikethrough text in the Field
- Thread starter naiphan
- Start date
- Local time
- Yesterday, 18:37
- Joined
- Feb 28, 2001
- Messages
- 30,073
Your biggest problem is going to be that Access is not a word processor like Word is. Strikethrough isn't going to be possible unless you have a FONT that already includes a strikethrough because Access doesn't have the direct ability to supply supplemental attributes in a single field.
Stated another way, you don't ask Word to do a relational join directly when doing a Mailmerge. Instead, you write an Access query and then do the merge on the query. Similarly, don't expect to define a word processing function and then implement it in something that isn't a word processor.
You could try something kinky like, if the text box is short enough, optionally superimpose a line on the textbox and control it separately when you want a strikethrough to show. Access could correctly print this, but you still won't be able to save a document containing the line. We are also probably talking about some VBA code to control that line based on some condition you would define.
When you try to save to Word for an Access report with lines, the lines vanish. Which occurs because Access is too stupid to save to Word format, but it can manage Wordpad (.rtf) format. Unfortunately, Wordpad does not know what to do with lines other than eat them.
Stated another way, you don't ask Word to do a relational join directly when doing a Mailmerge. Instead, you write an Access query and then do the merge on the query. Similarly, don't expect to define a word processing function and then implement it in something that isn't a word processor.
You could try something kinky like, if the text box is short enough, optionally superimpose a line on the textbox and control it separately when you want a strikethrough to show. Access could correctly print this, but you still won't be able to save a document containing the line. We are also probably talking about some VBA code to control that line based on some condition you would define.
When you try to save to Word for an Access report with lines, the lines vanish. Which occurs because Access is too stupid to save to Word format, but it can manage Wordpad (.rtf) format. Unfortunately, Wordpad does not know what to do with lines other than eat them.
- Local time
- Yesterday, 18:37
- Joined
- Feb 28, 2001
- Messages
- 30,073
There is one and only way I know of to do this. You have to create the document using Access to get the records but ActiveX (COM) methods and VBA code to open a Word application, create a new document, and generate the text one paragraph at a time. Then you could apply strikeover, underscore, hidden attribute, or whatever else you need. Tedious does not cover it by a long shot.
I hope the person asking for this can take "No" for an answer. If someone told me I had to do that or lose my job, my response would be unkind, probably inaccurate with respect to the person's true ancestry, and anatomically unlikely verging on impossible. This is NOT a task for the squeamish.
I hope the person asking for this can take "No" for an answer. If someone told me I had to do that or lose my job, my response would be unkind, probably inaccurate with respect to the person's true ancestry, and anatomically unlikely verging on impossible. This is NOT a task for the squeamish.
