I am currently working on an Access 2007 form (in an accdb file) with a form in a subform control in datasheet view. The subform is bound to a non-updatable recordset.
I would like the subform to appear they do in Access 2003; with a blue background colour after the last row however, in 2007, the background after the last row is white with faint gridlines and faint record selectors. I have looked at the form and subform control properties to see if there's anything new in Access 2007 that I can set to change the datasheet view so that the subform appears as subforms appear in Access 2003 however, I haven't been able to find anything (I have Access Options|Current Database|Document Window Options set to 'Overlapping Windows').
Any advice on how I can achieve this will be much appreciated.