[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 597
  • Last Modified:

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.
0
APD Toronto
Asked:
APD Toronto
  • 5
  • 2
2 Solutions
 
IrogSintaCommented:
Yes, just change the TextFormat property of the Textbox control that's bound to the memo field to Rich Text
0
 
Jeffrey CoachmanMIS LiasonCommented:
Or create a Memo field in the table, and set the TextFormat property of the Field to: Rich Text
0
 
Jeffrey CoachmanMIS LiasonCommented:
...hmmm
Actually Ron, you said the same thing here, but you were first...

Sorry about that
;-)

Jeff
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jeffrey CoachmanMIS LiasonCommented:
APD_Toronto,

Please disregard my post...

Jeff
0
 
APD TorontoAuthor Commented:
Would I be able to apply this to an SQL BE / Access FE?
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
0
 
APD TorontoAuthor 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.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<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
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now