Using strikethrough in a text field

[Kaccess]

Hello:

I'm wondering if anybody can help me.

I am printing reports and am trying to strikethrough phone numbers in the phone field based on the presence of a value in another field. Nothing happens with the code below: Any help would be appreciated, I'm new at this access thing. It probably shows.

If Me![NO_CONTACT_FLG] = "N" Then
Me![PHONE].Font.Strikethrough = True
Else
Me![PHONE].Font.Strikethrough = False
End If

 

[WayneRyan]

K,

As far as I know, strikethrough is not available.

Bold, Italic, Underline, Font Name, fontsize and fontweight are the only
things available for textboxes.

You might try a RTF control.

Is the font.StrikeThrough a VBA word thing?

Wayne

 

[Kaccess]

Thanks Wayne, I found some information that said I couldn't but I got my boss telling me I can. I get a few more responses like yours and I'll give them to him.

How would I use a RTF to accomplish this. Would I have to save it out to word and do the printed document from their.

I think I going to use this board more now then then.

 

[WayneRyan]

K,

Access isn't a Word Processor. It can store very large text entities, but
doesn't even support the turning the "fox" in "The quick brown fox" to red.
You can't even put it in italics (or bold). StrikeThrough is asking a little
bit too much.

There are third party add-ins that will let you do some of these things.
I'll try to post some links later.

In the interim, there are work-arounds. Conditional Formatting (use the
Search Facility here) can turn a field BOLD or red depending on conditions.

Wayne

 

[Rich]

Use a textbox with ;"-----------------------------------------------------------------------------------------------" as it's format, just toggle it based on your condition