Prev: Display a message box "this entry is a duplicate"
Next: �com vincular una imagen a cada registro de acces?
From: tighe on 3 Jun 2010 16:07
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" <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 3 Jun 2010 16:29
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" <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 3 Jun 2010 16:43
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" <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?
> >>
> >>
> >> .
> >>
>
>
> .
>
From: Rick Brandt on 4 Jun 2010 02:31
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.
From: KAREN on 5 Jun 2010 01:01

"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?
>>
>>
>> .
>>

First  |  Prev  | 
Pages: 1 2
Prev: Display a message box "this entry is a duplicate"
Next: �com vincular una imagen a cada registro de acces?