Prev: Run a file of SQL
Next: Access 97 and Windows 7 problem
From: Michiel Rapati-Kekkonen on 26 Mar 2010 13:03
Hi

I have a Text Box of which the Text Format is set to Rich Text.
The box is filled with texts containig certain elements that are surrounded
by brackets.
Those elements I would like to appear in a different color.

I have no experience (apart from some experimenting) with Rich Text, so I
don't even know if it is possible to colour several, different parts.
And then of course: How?

Any help appreciated!

Michiel


--- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
From: Allen Browne on 26 Mar 2010 23:22
Presumably this is Access 2007.

You can select the text, and then use the ribbon to set the text color.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Michiel Rapati-Kekkonen" <no-mail(a)nonsense.zz> wrote in message
news:hoipe1$1ebk$1(a)adenine.netfront.net...
> Hi
>
> I have a Text Box of which the Text Format is set to Rich Text.
> The box is filled with texts containig certain elements that are
> surrounded by brackets.
> Those elements I would like to appear in a different color.
>
> I have no experience (apart from some experimenting) with Rich Text, so I
> don't even know if it is possible to colour several, different parts.
> And then of course: How?
>
> Any help appreciated!
>
> Michiel
>
> --- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---

From: Michiel Rapati-Kekkonen on 27 Mar 2010 03:01
Thanks for your response, Allen,
at least now I see Something happen,
but
I would like to do it programmatically.
So far I can select, by code, the parts I want, but when I then apply '
..SelColor = vbRed '
the error message is 438: Object doesn't support this property or method.
It is an unbound texbox, Enabled, Unlocked, with Text format set to Rich.

I'm using 2007 indeed.

The question remains: is it possible?

Michiel



"Allen Browne" <AllenBrowne(a)SeeSig.invalid> wrote in message
news:P-Odnfm0us2O5zDWnZ2dnUVZ_qudnZ2d(a)westnet.com.au...
> Presumably this is Access 2007.
>
> You can select the text, and then use the ribbon to set the text color.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "Michiel Rapati-Kekkonen" <no-mail(a)nonsense.zz> wrote in message
> news:hoipe1$1ebk$1(a)adenine.netfront.net...
>> Hi
>>
>> I have a Text Box of which the Text Format is set to Rich Text.
>> The box is filled with texts containig certain elements that are
>> surrounded by brackets.
>> Those elements I would like to appear in a different color.
>>
>> I have no experience (apart from some experimenting) with Rich Text, so I
>> don't even know if it is possible to colour several, different parts.
>> And then of course: How?
>>
>> Any help appreciated!
>>
>> Michiel
>>
>> --- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
>


--- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
From: Allen Browne on 27 Mar 2010 07:43
Insert the HTML word around the desired text, e.g.:

Me.MyRichTextField = "This has a <font color=""#FF0000"">red</font> word."

You may need to use SelStart, Len(), Mid() etc to code this.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Michiel Rapati-Kekkonen" <no-mail(a)nonsense.zz> wrote in message
news:hokagn$10pp$1(a)adenine.netfront.net...
> Thanks for your response, Allen,
> at least now I see Something happen,
> but
> I would like to do it programmatically.
> So far I can select, by code, the parts I want, but when I then apply '
> .SelColor = vbRed '
> the error message is 438: Object doesn't support this property or method.
> It is an unbound texbox, Enabled, Unlocked, with Text format set to Rich.
>
> I'm using 2007 indeed.
>
> The question remains: is it possible?
>
> Michiel

From: Michiel Rapati-Kekkonen on 27 Mar 2010 11:30
Thanks, Allen, that's great.

This way it looks, unexpectedly, like a piece of cake.
And now it certainly looks better in my Rich Fields!

Michiel


"Allen Browne" <AllenBrowne(a)SeeSig.invalid> wrote in message
news:WuednT7WPL7lcjDWnZ2dnUVZ_oadnZ2d(a)westnet.com.au...
> Insert the HTML word around the desired text, e.g.:
>
> Me.MyRichTextField = "This has a <font color=""#FF0000"">red</font> word."
>
> You may need to use SelStart, Len(), Mid() etc to code this.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "Michiel Rapati-Kekkonen" <no-mail(a)nonsense.zz> wrote in message
> news:hokagn$10pp$1(a)adenine.netfront.net...
>> Thanks for your response, Allen,
>> at least now I see Something happen,
>> but
>> I would like to do it programmatically.
>> So far I can select, by code, the parts I want, but when I then apply '
>> .SelColor = vbRed '
>> the error message is 438: Object doesn't support this property or method.
>> It is an unbound texbox, Enabled, Unlocked, with Text format set to Rich.
>>
>> I'm using 2007 indeed.
>>
>> The question remains: is it possible?
>>
>> Michiel
>


--- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
 | 
Pages: 1
Prev: Run a file of SQL
Next: Access 97 and Windows 7 problem