Solved

HTML tags are showing in report

Posted on 2011-02-17
4
248 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
[X]
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
  • 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 40

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

726 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