Only change font fomat in select words within a memo field

[garvic82]

I would like to know if there is a way to change the font color only on
select words or areas within a memo field and save the changes? So, if I
want to either highlight or make some text red within a memo field how can I
change the font format and keep it. This would only apply to the selected
text within the memo field and the rest would remain the same default black
color.

Is this an event procedure in VB that can be done?

 

[Jeff Boyce]

You've described "how" you are trying to solve some business need, but
nothing about what that underlying need is.

If you'll explain a bit about it, folks here may be able to offer alternate
approaches that still gets the job done...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[garvic82]

Am I on the right path that this would call for the use of .selstart and/or
..sellength?

 

[garvic82]

It is my job to download the data into an Access database on a daily basis
and it's the end user that needs to monitor and edit the data once it is
there. They need to verify some data that is in a long memo field and
highlight some things that are not correctly stated. So, they need to select
some data/strings within this memo field and want the font to be in red and
highlighted in yellow once they have identified the string that needs
attention. These corrections will then be available for future reference and
easily identified by the distinct font format applied.

Does this help?

 

[Jeff Boyce]

So you're saying that comments are being added to a great big humongous pile
of comments (i.e., a memo field)?

Would it make it any easier if each comment got it's own record, instead of
having to try to find stuff within a memo field?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[tighe]

Garvic,

make sure the text box, on the form has Text Format set to Rich Text(data
tab of properties), as well as the table's memo field is rich text.

other than that there shouldn't be much to do except making sure the user
has access to the Font controls.

 

[garvic82]

I have tried it that way, but it just changes all of the text in the memo box
and not just what was selected. And I don't see an option to change this to
Rich Text in the Data Tab of this field property. I can only change size,
color, etc.

 

[garvic82]

No, nothing will be added to the memo field. There are legal and formal
reasons why we need to keep it in tact and just identify the areas that need
to be addressed. The length or contents of this memo field will not change.
It will just be used to identify problem areas for future reference and to
discuss with the person who entered the data in there (correct the paper, if
you will ). In the end the database will only keep the records which are
very few at a time where errors are identified.

 

[Rick Brandt]

I have tried it that way, but it just changes all of the text in the memo
box
and not just what was selected. And I don't see an option to change this
to
Rich Text in the Data Tab of this field property. I can only change size,
color, etc.

Are you using Access 2007 with the AccDB file format? You need that to use
Rich Text (actually HTML) in Access. For older versions you woudl have to
use a third party ActiveX control.

In either case format changes DO change what is stored in the database
because it adds the formatting tags to the data.

 

[KAREN]

It is my job to download the data into an Access database on a daily basis
and it's the end user that needs to monitor and edit the data once it is
there. They need to verify some data that is in a long memo field and
highlight some things that are not correctly stated. So, they need to
select
some data/strings within this memo field and want the font to be in red
and
highlighted in yellow once they have identified the string that needs
attention. These corrections will then be available for future reference
and
easily identified by the distinct font format applied.

Does this help?