Solved

HTML tags are showing in report

Posted on 2011-02-17
4
229 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

919 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now