Avatar of APD Toronto
APD Toronto
Flag for Canada asked on

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.
Microsoft AccessMicrosoft SQL ServerMicrosoft Office

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
IrogSinta

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jeffrey Coachman

Or create a Memo field in the table, and set the TextFormat property of the Field to: Rich Text
Jeffrey Coachman

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

Sorry about that
;-)

Jeff
Jeffrey Coachman

APD_Toronto,

Please disregard my post...

Jeff
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
APD Toronto

ASKER
Would I be able to apply this to an SQL BE / Access FE?
Jeffrey Coachman

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 Toronto

ASKER
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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Jeffrey Coachman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.