Datasheet form with Cond Formatting

[nancy54]

I have a datasheet form (created from a table) with some conditional formatting on the cells. Is there a way I can have a key somewhere on the form so users know what the colored cells indicate?

 

[arnelgp]

create a new form and add the datasheet form as subform.

 

[isladogs]

If you want to show what the conditional formatting colours mean, you could take a screenshot of the CF wizard and add an image control to the form with the datasheet itself added as a subform

 

[nancy54]

Thanks for you help,
I created a blank form for my formatting Key and inserted the main form as a sub form.
Another question- is it possible to get the form to sort by the ID field on open?

 

[isladogs]

Sorry missed this reply earlier.
Just alter the record source for the form so it sorts by ID.
If using SQL, then add ORDER BY ID