Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
Course Of The Month
11 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Rich Text in Access
Posted on 2012-12-28
Hello Experts,
Is it possible in anyway to have a Memo field (or another type) that will accept rich text (bold, underline, color, etc.)
Thank you.
Is it possible in anyway to have a Memo field (or another type) that will accept rich text (bold, underline, color, etc.)
Thank you.
[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
5-
2
8 Comments
Yes, just change the TextFormat property of the Textbox control that's bound to the memo field to Rich Text
Active 7 days ago
Or create a Memo field in the table, and set the TextFormat property of the Field to: Rich Text
Active 7 days ago
...hmmm
Actually Ron, you said the same thing here, but you were first...
Sorry about that
;-)
Jeff
Actually Ron, you said the same thing here, but you were first...
Sorry about that
;-)
Jeff
Active 7 days ago
You did not mention SQL BE in your original post...
Rich text is really HTML, so you can store it in SQL as a string, ...displaying it formatted may be a different issue though...
But you will have to tell us a bit more about the exact need here:
Formatting individual records?
Pasting Formatted text from external sources.
Inserting HTML formatted strings.
Displaying stored HTML strings.
...etc
JeffCoachman
Rich text is really HTML, so you can store it in SQL as a string, ...displaying it formatted may be a different issue though...
But you will have to tell us a bit more about the exact need here:
Formatting individual records?
Pasting Formatted text from external sources.
Inserting HTML formatted strings.
Displaying stored HTML strings.
...etc
JeffCoachman
Active today
Well, this will be a project managing app, so I will need rich text as a description. It make sence that it is actually html, but how would I go about it?
I was really hoping in my Access FE to have a text box that will have icons just as this EE text box with icons for bold, italic, underline, etc.
For pasting, I'm not too worried, as I can either paste it plain text then format it in Access, or paste HTML direct in my BE. I'm more concerned re the icons, being able to do a report with rich text, and export the rich text report in Word or PDF.
I was really hoping in my Access FE to have a text box that will have icons just as this EE text box with icons for bold, italic, underline, etc.
For pasting, I'm not too worried, as I can either paste it plain text then format it in Access, or paste HTML direct in my BE. I'm more concerned re the icons, being able to do a report with rich text, and export the rich text report in Word or PDF.
Active 7 days ago
<Well, this will be a project managing app, so I will need rich text as a description>
But in what way specifically...?
As I asked:
Formatting individual records?
Pasting Formatted text from external sources.
Inserting HTML formatted strings.
Displaying stored HTML strings.
...Please clarify...
<It make sence that it is actually html, but how would I go about it?>
Go about what specifically?
IrogSinta has told you how to create a Rich text Field/control
<I was really hoping in my Access FE to have a text box that will have icons just as this EE text box with icons for bold, italic, underline, etc.>
The same functionality exists in a Rich text field.
Either you can use the formatting tools on the ribbon, ...or select all the text in the control, ...and a transparent, floating formatting toolbar will appear.
JeffCoachman
But in what way specifically...?
As I asked:
Formatting individual records?
Pasting Formatted text from external sources.
Inserting HTML formatted strings.
Displaying stored HTML strings.
...Please clarify...
<It make sence that it is actually html, but how would I go about it?>
Go about what specifically?
IrogSinta has told you how to create a Rich text Field/control
<I was really hoping in my Access FE to have a text box that will have icons just as this EE text box with icons for bold, italic, underline, etc.>
The same functionality exists in a Rich text field.
Either you can use the formatting tools on the ribbon, ...or select all the text in the control, ...and a transparent, floating formatting toolbar will appear.
JeffCoachman
Featured Post
This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes a serious pitfall that can happen when deleting shapes using VBA.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Viewers will learn how the fundamental information of how to create a table.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 5 hours left to enroll
628 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.