Solved

HTML tags are showing in report

Posted on 2011-02-17
4
232 Views
Last Modified: 2012-05-11
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
Comment
Question by:shogun5
  • 3
4 Comments
 

Author Comment

by:shogun5
ID: 34923713
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
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 34924004
May be you can save report as html or pdf?
0
 

Author Comment

by:shogun5
ID: 34925559

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
 

Author Closing Comment

by:shogun5
ID: 34925578
Answer was not entirely provided but help me accept a resolve.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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 …

809 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