Setting Colours On SubForm Datasheets

[JCarmic]

I have a form with various records on a datasheet subform ie JobHeader and then various job details.
Is it possible to change the colour of a row on a datasheet dependent upon the value of a cell within that row
I wish to do this to highlight jobs that have been computer generated as opposed to manually entered. I know I could do this as two queries but I would like all the job details together if possbile

Thanks in advance for any help you could give me

John

 

[Atomic Shrimp]

What you're after is conditional formatting, which is built-in with Access 2000, in A97 it can be done, but not with a datasheet form, however it does work with a continuous form which be made to look almost the same as a datasheet...

... have a look at this topic for more details: http://www.access-programmers.co.uk/ubb/Forum4/HTML/002156.html

Mike

[This message has been edited by Mike Gurman (edited 02-27-2001).]