There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
Rich Text in Access
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.
Asked:
5-
2
2 Solutions
LVL 29
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
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
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now