From: garvic82 on
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?
From: Jeff Boyce on
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" <garvic82(a)discussions.microsoft.com> wrote in message
news:05D5B6DD-B432-4925-A764-F34EC93A0430(a)microsoft.com...
>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?


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

"garvic82" wrote:

> 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?
From: garvic82 on
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" wrote:

> 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" <garvic82(a)discussions.microsoft.com> wrote in message
> news:05D5B6DD-B432-4925-A764-F34EC93A0430(a)microsoft.com...
> >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?
>
>
> .
>
From: Jeff Boyce on
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.

"garvic82" <garvic82(a)discussions.microsoft.com> wrote in message
news:A2B84AB9-E6B7-4857-A77B-817AAB47FF51(a)microsoft.com...
> 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" wrote:
>
>> 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" <garvic82(a)discussions.microsoft.com> wrote in message
>> news:05D5B6DD-B432-4925-A764-F34EC93A0430(a)microsoft.com...
>> >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?
>>
>>
>> .
>>