Rich Text in Access

APD Toronto
APD Toronto used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Yes, just change the TextFormat property of the Textbox control that's bound to the memo field to Rich Text
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Or create a Memo field in the table, and set the TextFormat property of the Field to: Rich Text
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
...hmmm
Actually Ron, you said the same thing here, but you were first...

Sorry about that
;-)

Jeff
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
APD_Toronto,

Please disregard my post...

Jeff
APD TorontoSoftware Developer

Author

Commented:
Would I be able to apply this to an SQL BE / Access FE?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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
APD TorontoSoftware Developer

Author

Commented:
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.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
<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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial