Conditional formatting stock quantity - help!

[T]

Hi,

I am new to microsoft access and am trying to build a database for stock
control as part of a college project.

I have just discovered conditional formatting and would like to make my
database work so that if the stock falls below a certain number it turns red
- which would indicate that the stock is low. I've managed to do this but I
was hoping that I could do this for each individual item in my form but as it
stands when I conditional format the quantity the whole list obeys this rule.

Is it possible to conditional format each individual part in my table?

Many thanks for your help!

 

[John W. Vinson]

Is it possible to conditional format each individual part in my table?

Well, not in a Table - but then you shouldn't be looking at table datasheets
in any case. In a Form using actual *conditional formatting* rather than
setting the Format property of controls on the form, then yes, that's exactly
what the feature is designed to do!

Please explain how you're setting the conditional format, and where.

 

[Ken Sheridan]

If you want to use a different quantity for each item to determine when it
shows as red then you need to store the number in a column in the table. Add
a column, ReorderLevel say, of number data type to the inventory table and in
this enter the number below which you want to change the colour to red for
each item, so one might be 10 another 15, another 20 and so on. The
ReorderLevel field must be in the form's underlying RecordSource of course.

In the conditional formatting dialogue for the 'stock in hand' control in
form design view select 'Field Value Is' in the left combo box, 'less than'
in the centre one, and enter [ReorderLevel], including the square brackets.

Ken Sheridan
Stafford, England