UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Change Text Color In A Table?, Access 2000    
 
   
wmix
post Apr 9 2019, 05:23 PM
Post#1



Posts: 43
Joined: 12-April 17



Hi Everyone,
I'm not sure it's even possible, but I cannot seem to find an answer directly. I've found a lot of information about using conditional formatting but that's not an option on a table. I was thinking that it sure would be nice to have this type of formatting at a basic table level (thought maybe it's just not an access option).

I table with basic info in it including:
MachineID (PK)
MachineName
InactiveDate
etc...

What I was hoping was that if InactiveDate is not NULL then everything associated with that MachineID (the row) would be a different color than black text. Or the background could be light grey or something.

I was hoping this would allow users to instantly spot "inactive" machines on a form in a combo box, list box, etc.

If it cannot be done on a table level can anyone offer advice on doing it using SQL in a query so a combo box or list box based on a query has the color formatting?

Thank you for any advice you can offer.
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    22nd July 2019 - 10:59 AM