access tables

[Guest]

can I add color to specific records in a table, can it be conditional?
My database is tracking inventory and I'd like items no longer purchased
after a certain date to be gray background.
thank you

 

[Rick B]

You can do so in your forms and reports. A table is not designed to be used
by the end user; it is just a bucket to hold the records. Once the database
is built, you should not be working in the tables at all.

To do what you want, use conditional formatting in your forms and reports.
You'd also have to add an "inactive" checkbox to your table if I understand
your post correctly.

 

[Guest]

Not to a table, you can add colors to Forms or Reports using the conditional
formatting, but it will be for specific field and not for the all record.

 

[Guest]

Thank you Rick B.
I use my tables all the time. One table that holds all the items in my
inventory I use daily. It is related to the purchases made on each item and I
use it to track purchase history with one click. Is that wrong? Is there a
better way?
thank you, jw

 

[Rick B]

Yes. You should use forms. Tables are the buckets used to store your
records, but forms, queries, and reports are the objects intended to be used
by the user to manipulate data.