Format certain items in a list depending on record

C

coreym123

I have list of Product Names from the Product table. When a user
clicks on a Product Name, that record pops up in a subform. Under Row
Source I have an SQL statement that gathers all the product names. Is
it possible do, for example, make list items red for those products
that lack descriptions? That way, the user would see in the list
which products they would have to go in and edit. As a description
was added to a product, its item in the list would turn black again.

Any advice would be much appreciated!

Thanks,
Corey
 
J

James

I have list of Product Names from the Product table.  When a user
clicks on a Product Name, that record pops up in a subform.  Under Row
Source I have an SQL statement that gathers all the product names.  Is
it possible do, for example, make list items red for those products
that lack descriptions?  That way, the user would see in the list
which products they would have to go in and edit.  As a description
was added to a product, its item in the list would turn black again.

Any advice would be much appreciated!

Thanks,
Corey
Click to expand...

Hi

Sure, you could put in some conditional formatting. When in form
design select Formatting | Conditional formatting to select your
criteria or have a look at the in-built help that has quite extensive
information on the subject.

Regards
 
Top