Solved

HTML tags are showing in report

Posted on 2011-02-17
4
226 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
Comment Utility
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
Comment Utility
May be you can save report as html or pdf?
0
 

Author Comment

by:shogun5
Comment Utility

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
Comment Utility
Answer was not entirely provided but help me accept a resolve.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

772 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

11 Experts available now in Live!

Get 1:1 Help Now