A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

changing fore color of each column in the List Box



 
 
Thread Tools Display Modes
  #1  
Old August 19th, 2005, 04:00 AM
k0_zaw
external usenet poster
 
Posts: n/a
Default changing fore color of each column in the List Box

I found a way to coloring the font for each column in the list box finally
but not programatically in Access 2003.
Just add color value in the source table's fields that your want to in the
list box. (remember in the source table but not in the query or string.)
For E.g: for text fields: Format: @[magenta];"nil"

@ just show exact value of the filed with color Magenta. How interesting !
You may already know, but I just know Today and sharing happines!

Quote from Ms Access Help
[color] Display the formatted data in the color specified between the
brackets. Available colors: Black, Blue, Green, Cyan, Red, Magenta, Yellow,
White.
UnQuote

--
Brgds,
k0_Zaw
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Worksheet Functions 12 April 17th, 2005 10:36 PM
how do i find out what is uncommon in column list A1: A10 and B1:. ykas General Discussion 2 April 12th, 2005 04:26 PM
how do i find out what is uncommon in column list A1: A10 and B1:. vikasarora07 General Discussion 1 April 12th, 2005 03:47 PM
Linking a Column List to a Row List Moe General Discussion 2 November 1st, 2004 08:09 PM
Add Tel # area code to column list Peo Sjoblom Worksheet Functions 2 May 8th, 2004 03:26 AM


All times are GMT +1. The time now is 05:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.