Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-06-2014, 10:21 AM   #1
gsrajan
Newly Registered User
 
Join Date: Apr 2014
Posts: 111
Thanks: 60
Thanked 0 Times in 0 Posts
gsrajan is on a distinguished road
Memo Field in Rich Text Box

When I changed the memo field from plain text to Rich Text, I got the below divs and slashes. Is there any way to get rid of them?



<div>GC in process - EB1.</div>
<div>&nbsp;</div>

I had only "GC in process - EB1" in plain text.

Thank you.

gsrajan is offline   Reply With Quote
Old 05-06-2014, 10:46 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,343
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Memo Field in Rich Text Box

the divs and slashes are the html formatting codes, if you view the text in rich text, you won't see them.

However if you have saved a number of records with this formatting and don't want it the way to get rid of them is to use the plaintext function

you'll need to run an update query to update your memo field - something like

Quote:
UPDATE myTable SET myMemoField=plaintext(myMemoField)
Alternatively modify all your forms and the table to use rich text for the memo field
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Rich Text in Memo Field- Question RHubbard Tables 4 09-12-2014 02:24 PM
Memo Field Rich Text shamas21 Tables 5 11-21-2013 04:15 AM
Can't Create a Rich Text Memo Field dancole42 Tables 6 02-10-2013 03:56 AM
rich text memo field jedder18 Reports 5 05-11-2012 05:12 PM
Rich text format in memo field Dick7Access General 4 07-10-2009 04:06 PM




All times are GMT -8. The time now is 02:52 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