Ask Your Question

How to I add a colour on the QTY when it is low?

asked 2017-06-08 17:58:03 +0100

Jordan.Milne gravatar image

Hi again, not sure if its possible, but can and how do you change colour when the inventory/QTY is 1 or 0, if possible I would Like 1 Amber and 0 Red. Please find attached an image. I really hope this is possible. C:\fakepath\Picture1.png

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-06-08 18:22:28 +0100

Ratslinger gravatar image

For one thing, your image is displaying the table data view in a query. There is little or nothing which can be changed in that view. If this were a control on a form, it is possible to do but only with macro coding. If you have no background in doing this it is a steep learning curve.

edit flag offensive delete link more


Ok, Thank you Ratslinger, I think I may leave it then.

Jordan.Milne gravatar imageJordan.Milne ( 2017-06-22 09:44:57 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-08 17:58:03 +0100

Seen: 28 times

Last updated: Jun 08 '17