Change Text color dynamically

[Alireza355]

Dear all,

I remember having an old MS-DOS accounting application, that viewed numbers in different collors for each thousand seperator. for example:

12,345,233,678,000

the 000 was for example in black
768 was in red
233 was in yello
345 was in blue
12 was in orange

is this possible in access 2003 datasheets and textboxes??????????

[ADezii]

@Alireza355
To the best of my knowledge, this cannot be done in any Access Versions prior to 2007 without using an External ActiveX Control. I think Access 2007 natively supports the Rich Text Format, where this would then be possible. I'm sure that other Members will soon shed more light on your question.

[missinglinq]

It would, as has been said, require using RTF, and I'm not sure that that's available, even in 2007, for Datasheets.

Linq ;0)>.

[mshmyob]

Actually Rich Text is only supported in Memo fields and not text fields in AC2007. As previously noted I have never seen it done natively in Access.

cheers,

[missinglinq]

I don't run 2007 and thus can't check it myself, but Allen Browne, who's usually correct, lists this as being available in all textboxes, whether bound to bound/unbound text fields or Memo fields.

http://allenbrowne.com/Access2007.html

Linq ;0)>

[mshmyob]

You are quite correct Linq. I just tried it and it works. I was going by a MS article that indicated only Memo fields set in a table had the functionality. I had never actually tried an unbound text box but as you say it works perfectly.

I just wish MS had incorporated HTML image functionality. I needed that for a project but am currently using a browser control.

Thanks for the extra info.

cheers,


@missinglinq

[ADezii]

You could actually perform a 'cheap imitation' with multiple, properly Aligned and Formatted Text Boxes, some trick coding, but I don't know that it would be worth the effort. If you are interested, I can post a simple Demo.