Change font color at whim

[EVP]

Simple question (I hope),

When users enter text in the comments box, I want the ability to highlight and change some text to red (like in excel). Any idea how to do this?
I'm currently using the code: SomeControle.ForeColor = vbred
in the fore color box to keep the effect to only one cell (and not the whole column), but this changes all the text in the cell.

Any help would be appreciated.
Thanks.

 

[Mile-O]

First thing: always remember Excel is not Access; Access is not Excel. If you can do one thing in one then you shouldn't expect it to be possible in the other. They are for completely different purposes.

Yes, in Excel, you can perform a colour change to individual characters in a cell. In an Access cell you have no need to do this as the tables shouldn't be visible to the user.

But, by cell, I'm sure you mean a textbox on a form. Again, this is not directly possible with the default textbox object. You would have to install and register the rich textbox ActiveX control. I don't know if this ships with Access 2000 or 2002 but I haven't seen it in Access 97 - to be honest I've never went looking for it. I use it, however, when using Visual Basic 6 - it's a default control there.

 

[Rich]

Rich Text Control is available via the Developer Edition, or a third party such as FMS

 

[theatreman]

Simple question (I hope),

When users enter text in the comments box, I want the ability to highlight and change some text to red (like in excel). Any idea how to do this?
I'm currently using the code: SomeControle.ForeColor = vbred
in the fore color box to keep the effect to only one cell (and not the whole column), but this changes all the text in the cell.

Any help would be appreciated.
Thanks.

Have you tried playing around with 'conditional formatting' on the 'format' tab? I have use it to hilite when something doesn't match the expected answer.

 

[Mile-O]

Re: Re: Change font color at whim

Have you tried playing around with 'conditional formatting' on the 'format' tab? I have use it to hilite when something doesn't match the expected answer.

He means to perform actions wherby different characters can be off a different colour.

 

[mr moe]

Any of you guys figured out how to do it. I need to do the same if it's possible. thanks.

 

[Mile-O]

Any of you guys figured out how to do it. I need to do the same if it's possible. thanks.

Well:

You would have to install and register the rich textbox ActiveX control.

Rich Text Control is available via the Developer Edition, or a third party such as FMS

THAT's how you do it!

 

[mr moe]

Ok I was able to use Rich Text Control, but the problem is when I try to show the value on a report, the report shows the code of the RTF and not the formatted value, how do I fix that. Any expert out there can tell me?

 

[Mile-O]

the report shows the code of the RTF and not the formatted value

What code? You aren't using BBCode or HTML tags in it are you?

To use the rich text box you need to use its properties which I can't remember offhand but you are required to select areas of text using the SelStart and SelText properties and then assign formats to the selected text.

 

[mr moe]

This attachment will explain what I said above. thanks.