A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Only change font fomat in select words within a memo field



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 07:34 PM posted to microsoft.public.access
garvic82
external usenet poster
 
Posts: 9
Default Only change font fomat in select words within a memo field

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?
  #2  
Old June 3rd, 2010, 07:43 PM posted to microsoft.public.access
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Only change font fomat in select words within a memo field

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" wrote in message
...
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?



  #3  
Old June 3rd, 2010, 08:19 PM posted to microsoft.public.access
garvic82
external usenet poster
 
Posts: 9
Default Only change font fomat in select words within a memo field

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?

  #4  
Old June 3rd, 2010, 08:41 PM posted to microsoft.public.access
garvic82
external usenet poster
 
Posts: 9
Default Only change font fomat in select words within a memo field

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" wrote in message
...
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?



.

  #5  
Old June 3rd, 2010, 08:48 PM posted to microsoft.public.access
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Only change font fomat in select words within a memo field

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" wrote in message
...
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" wrote in message
...
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?



.



  #6  
Old June 3rd, 2010, 09:07 PM posted to microsoft.public.access
tighe
external usenet poster
 
Posts: 53
Default Only change font fomat in select words within a memo field

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" wrote:

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" wrote in message
...
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?



.

  #7  
Old June 3rd, 2010, 09:29 PM posted to microsoft.public.access
garvic82
external usenet poster
 
Posts: 9
Default Only change font fomat in select words within a memo field

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.



"tighe" wrote:

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" wrote:

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" wrote in message
...
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?


.

  #8  
Old June 3rd, 2010, 09:43 PM posted to microsoft.public.access
garvic82
external usenet poster
 
Posts: 9
Default Only change font fomat in select words within a memo field

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.

"Jeff Boyce" wrote:

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" wrote in message
...
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" wrote in message
...
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?


.



.

  #9  
Old June 4th, 2010, 07:31 AM posted to microsoft.public.access
Rick Brandt
external usenet poster
 
Posts: 4,354
Default Only change font fomat in select words within a memo field

garvic82 wrote:

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.
  #10  
Old June 5th, 2010, 06:01 AM posted to microsoft.public.access
KAREN
external usenet poster
 
Posts: 1
Default Only change font fomat in select words within a memo field


"garvic82" wrote in message
...
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" wrote in message
...
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?



.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.