Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

HTML tags are showing in report

Dear Experts,

I have a text box of memo type. I set the Enter Key Behavior to "New Line in Field" and Text Format to "Rich Text". This allows users to bold text, enter bullets etc. The problem is that when users do this the formatted text display on the report with html tags. How do I get the report to show bold.

Use the following code on the button object to print the report:

 DoCmd.OutputTo acOutputReport, "rptTrip", acFormatRTF

So report comes out in .rtf format.

Any ideas?

Thanks!
screenshot-access.jpg
screenshot-access1.jpg
0
shogun5
Asked:
shogun5
  • 3
1 Solution
 
shogun5Author Commented:
Experts,

Please note that ultimately I need to keep the formatting, i.e. bold on the page if possible. I do not wish to change the text format of the memo field from Rich Text to Plain text. I know doing so would remove the HTML tags but the whole purpose of formatting the text ont he screen is so that text would come out on the page as is formatted on the screen. I really hope there is a way to do this. Otherwise I will not be able to use Access. Users must be able to created indented bullets and bold text.

Hope someone has some ideas :-)
0
 
als315Commented:
May be you can save report as html or pdf?
0
 
shogun5Author Commented:

All,

Found answer here:

http://www.accessmonster.com/Uwe/Forum.aspx/access/92896/Rich-Text-formatting-in-Access-2007

It turns out that you can't keep the formatting in an .rtf file. That's too bad! Access should have allowed us to output to a .doc file and keep all Rich Text formatting. Anyway, I am forced to output to .pdf. I really wanted to output to .doc or .rtf (with formatting) so recipients that do have have Adobe Acrobat can open the file.

I will award als315: the points. I knew how to output to .pdf

but looks like this is the only way I can keep the formatting. :-(

TheDate = Month(Date) & "-" & Day(Date) & "-" & Year(Date)
 TheFile = CurrentProject.Path & "\TripReport-" & TheDate & ".pdf"

Open in new window

0
 
shogun5Author Commented:
Answer was not entirely provided but help me accept a resolve.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now