var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Changing the colour of specific rows in a datasheet
I have built a form that displays a query in datasheet view. Please see attached .jpg. One of the fields is Stock Category giving you the following options:
I would like the text or cell colour of the row to change colour depending on Stock Category selected. eg. Sold items would be displayed in red, Internal Use in black
Is this possible? If so how? My knowledge of VB Code is limited so the more detail the better!
Look forward to hearing from you
Presuming you have A2k or later, Conditional Formatting would be the easiest way to achieve what you're after. More info available in Help.
Brilliant, didn't realise it was that easy!
Ok from the .jpg you can see that I have quite a few fields. If StockCategory shows "SOLD" how do I get StockType to display in red? What is the expression I can use?
did you actually try conditional formatting to see what it could do for you?
incidentally I would try to get away from using datasheets for data entry - you are very limited in what you cna do and its easy to make inadvertant errors in the data (such as changing the wrong row(s),
Change the first field to "Expression is" and then put
[StockCategory] = "SOLD"
in the second field
Thanks for all your help! Working perfectly!
Hey Paul and Happy New Year to ya.... It's been a while and hope all is well with you.
Originally Posted by