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

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.


--
Rick B



"jw" <(E-Mail Removed)> wrote in message
news:297AEFD7-C3BE-448B-9D6C-(E-Mail Removed)...
> 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

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.

--
\\// Live Long and Prosper \\//
BS"D


"jw" wrote:

> 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

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" wrote:

> 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.
>
>
> --
> Rick B
>
>
>
> "jw" <(E-Mail Removed)> wrote in message
> news:297AEFD7-C3BE-448B-9D6C-(E-Mail Removed)...
> > 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
>
>
>

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.


--
Rick B



"jw" <(E-Mail Removed)> wrote in message
news:7ECDF889-575B-4FE7-A6FF-(E-Mail Removed)...
> 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" wrote:
>
>> 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.
>>
>>
>> --
>> Rick B
>>
>>
>>
>> "jw" <(E-Mail Removed)> wrote in message
>> news:297AEFD7-C3BE-448B-9D6C-(E-Mail Removed)...
>> > 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
>>
>>
>>