We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
Active 1 day ago
Yes, just change the TextFormat property of the Textbox control that's bound to the memo field to Rich Text
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 1 day ago
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.
<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
Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
- Acronis
- Software-Other
- Ransomware
- Microsoft Office
- Security
- *Backup Software
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses
Course of the Month5 days, 18 hours left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.