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    
post Apr 9 2019, 05:23 PM

Posts: 46
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)

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    6th August 2020 - 07:34 PM