By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,490 Members | 1,774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,490 IT Pros & Developers. It's quick & easy.

Change Text color dynamically

Alireza355
P: 86
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??????????
Apr 19 '09 #1
Share this Question
Share on Google+
6 Replies


ADezii
Expert 5K+
P: 8,679
@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.
Apr 19 '09 #2

missinglinq
Expert 2.5K+
P: 3,532
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)>.
Apr 19 '09 #3

mshmyob
Expert 100+
P: 904
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,
Apr 19 '09 #4

missinglinq
Expert 2.5K+
P: 3,532
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)>
Apr 20 '09 #5

mshmyob
Expert 100+
P: 904
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
Apr 20 '09 #6

ADezii
Expert 5K+
P: 8,679
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.
Apr 21 '09 #7

Post your reply

Sign in to post your reply or Sign up for a free account.