Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-09-2017, 10:22 AM   #1
sxschech
Newly Registered User
 
Join Date: Mar 2010
Posts: 582
Thanks: 23
Thanked 106 Times in 95 Posts
sxschech is on a distinguished road
html tags in report after edit table data

I imported text from a word doc via an excel table (paste word data into excel file, link into access then run append query into local access table). Results are printed out to pdf. Datatype for field is Long and report field is plain text.

  • If I print out the data as is, all looks fine.
  • If I correct a typo in the data directly in the access table and then print the report, it seems to get wrapped in html tags.
  • The only way so far to get around this is to delete the data, correct it in the excel file and reimport.

One of the text fields on the report has conditional formatting, could that be why? (wouldn't explain why the other text field exhibits same behavior without formatting)
Code:
[correct]=True And [txtHideAnswers]="No"
Example:
1. Why is these problem occurring?

After editing data output looks like:
1. <div>Why is this problem occurring?</div>

sxschech is offline   Reply With Quote
Old 02-09-2017, 12:05 PM   #2
sneuberg
AWF VIP
 
Join Date: Oct 2014
Location: Tucson, Arizona
Posts: 3,506
Thanks: 362
Thanked 975 Times in 943 Posts
sneuberg will become famous soon enough sneuberg will become famous soon enough
Re: html tags in report after edit table data

Rich text format (RTF) is represented internally with HTML. I'd expect something like you are getting if the table's long text field is set to RTF and the report's field is plain text as you said it is. I'd first try making both RTF as that might preserve some of the initial formatting. If that doesn't work then make them both plain text.
__________________
And now nothing will be restrained from them, which they have imagined to do. Genesis 11:6

Steve
sneuberg is offline   Reply With Quote
The Following User Says Thank You to sneuberg For This Useful Post:
sxschech (02-09-2017)
Old 02-09-2017, 01:22 PM   #3
sxschech
Newly Registered User
 
Join Date: Mar 2010
Posts: 582
Thanks: 23
Thanked 106 Times in 95 Posts
sxschech is on a distinguished road
Re: html tags in report after edit table data

Thanks sneuberg. I took another look at the table design general properties and one of the long fields was plain text, the other was rich text. I changed it to plain and it no longer displays html tags. Now that I recall, I think originally I had all as rich text and discovered that there was a truncation issue on the report and changed the text boxes on the report to plain text and the fields in the table, but looks like I didn't change all affected fields in the table properties.

sxschech is offline   Reply With Quote
Old 03-29-2017, 01:56 PM   #4
sxschech
Newly Registered User
 
Join Date: Mar 2010
Posts: 582
Thanks: 23
Thanked 106 Times in 95 Posts
sxschech is on a distinguished road
Re: html tags in report after edit table data

Recently came across this, as another option besides having to change the table properties. Seems there is a plaintext function and that will not print out those invisible html tags on the report.

http://www.justanswer.com/microsoft-...html-tags.html

Code:
SELECT Field1, Field2,..., plaintext(tblGlossary.Definition) AS Definition
FROM tblGlossary

sxschech is offline   Reply With Quote
The Following User Says Thank You to sxschech For This Useful Post:
sneuberg (03-29-2017)
Reply

Tags
conditional formatting , html tags , pdf , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
HTML tags displayed in table teel73 Tables 1 01-19-2015 10:17 AM
Remove HTML and RTF Tags from String GohDiamond Queries 3 12-06-2013 03:00 PM
Question Use variable between HTML tags byTimber General 3 09-30-2012 09:47 AM
Removing html tags from Access 2007 TimE General 1 02-26-2009 06:51 AM




All times are GMT -8. The time now is 03:28 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World