Changing Test Color to alert user

[dtlabo]

Hello, and thanks in advance for any iput.

I have an MS Access 2000 database that is connected to a MS SQL Server
tables via ODBC. The database displays order information depending on
the Order Number entered by the user. This database consist of a Main
form that show items like Customer Ship To Address, Expected Ship Date,
Prefered Carrier ect, and a subform that shows the Order's line level
detail (Part Number, Description, Ordered Qty, Picked Qty etc.). The
main form pulls it's information from two tables PickHeader, and the
subform pulls it's data from the PickDetail table. We have a third
table called HazardPartNbrs. The HazardPartNbrs contains a list of Part
Numbers that are know Hazards and that need to be shipped with
Hazardous Paperwork etc.

What I would like to do is change the color of the Part Number for any
item that is displayed in the subform if that part number shows up in
the Hazardous table, to red. If the Part Number does not show up in the
Hazardous Table then the color will remain defaul (black) color. The
subform is a continuous form

Thanks Again !!!
Del

 

[Sandra Daigle]

Take a look at conditional formatting. This tool allows you to do some basic
formatting based on conditions that you set. From the form designer select
the control, then click Format->Conditional Formatting.