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

Welcome to UtterAccess! Please ( Login   or   Register )

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



Posts: 41
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
 
DanielPineault
post Apr 9 2019, 05:36 PM
Post#2


UtterAccess VIP
Posts: 6,509
Joined: 30-June 11



No, it is not possible.
Since no one should directly be using tables, this wouldn't make sense. Data should be accessed through forms where you can add control, validation and ... conditional formatting. Simply create a continuous form and add the appropriate conditional formatting and you'll be set.

--------------------
Daniel Pineault (2010-2018 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
wmix
post Apr 10 2019, 02:01 PM
Post#3



Posts: 41
Joined: 12-April 17



Thank you Daniel for your reply.
I do have it set up so the end-users are not using the table.
I was just trying to come up with a way to easily identify these specific machines for end-users when they look at a combo box or list box when searching for a machine.
I'll see what else I can figure out.
Go to the top of the page
 
RJD
post Apr 10 2019, 02:20 PM
Post#4


UtterAccess VIP
Posts: 9,574
Joined: 25-October 10
From: Gulf South USA


Hi:

QUOTE
I was just trying to come up with a way to easily identify these specific machines for end-users when they look at a combo box or list box when searching for a machine. I'll see what else I can figure out.

Here's an idea ... in the row source query for the combobox or listbox (if a table now, make it a query) add a field like this ...

Status: IIf(Not IsNull([InactiveDate]),"Inactive","") ... Design View format

... then show this column in the combobox or listbox (add a column to the column count and give it a width). This can be the indicator instead of a color.

Or, if you don't want the user to ever choose an inactive machine, just use a WHERE clause in the row source query to eliminate them.

Just a thought.

HTH
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
wmix
post Apr 11 2019, 12:51 PM
Post#5



Posts: 41
Joined: 12-April 17



Thank you Joe.
I'll take a look and see if I can figure this out.
I never thought it was an issue until the company owner sat down to use the system one day and mentioned it was confusing. Unfortunately we cannot hide the inactive machines because sometimes we have to look back at them.
Go to the top of the page
 
RJD
post Apr 11 2019, 06:48 PM
Post#6


UtterAccess VIP
Posts: 9,574
Joined: 25-October 10
From: Gulf South USA


You are very welcome.

Let us know if we can assist you further in setting this up. If so, that will usually require you posting a cutdown db with relevant objects (no sensitive data of course, and zipped).

Best of luck ...

Regards,
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
isladogs
post Apr 12 2019, 01:39 AM
Post#7



Posts: 1,304
Joined: 4-June 18
From: Somerset, UK


Whilst I agree with previous advice, you can do some formatting in queries, listboxes, comboboxes and indeed tables.
This article on my website give an idea about what is possible Add Colour

--------------------
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    24th April 2019 - 01:02 PM