Datasheet visual change in 2010?

[Leif]

I'm moving from Access 2003 to 2010. I have a form with a subform. The subform is in datasheet view. I've noticed that while in 2003 rows below the "add" (final) row are grayed, in 2010 the rows appear in a white background with a lighter border color.

The change may have occurred in 2007, but since I'm passing that I don't know.

The user prefers the way the datasheet was displayed in 2003. Is there any way to change the subform so that rows below the add row are grayed as in 2003?

Thanks.

 

[CJ_London]

Not so far as I am aware.

 

[JHB]

I'm moving from Access 2003 to 2010. I have a form with a subform. The subform is in datasheet view. I've noticed that while in 2003 rows below the "add" (final) row are grayed, in 2010 the rows appear in a white background with a lighter border color.

Isn't each second row which change?

 

[CJ_London]

Isn't each second row which change?

Yes - although you can change the properties for that - the OP is talking about a form which is sized to take say 10 rows, and has 3 rows populated plus 1 for new record, leaving 6 'blank' rows. It is the colour of these 6 rows he is referring to.

Having said that, I have found this property which is not set until used

Me.DatasheetBackColor = vbYellow

Put it in the form open event. Change the colour to one that you prefer but note this also affects alternate lines 'used', so you have have additional work to do (using me.detail.backcolor and me.detail.alternatebackcolor etc)

 

[CJ_London]

Sorry - forgot to include the link - it is for 2003 but works for 2010

http://msdn.microsoft.com/en-us/library/office/aa224203(v=office.11).aspx

 

[Leif]

But it is set for all rows, right? Used and unused rows. I want the standard white on used or the new record row, and gray for the other non-used areas in datasheet view. Or perhaps easier said, I want the same display that is defaulted in 2003.

 

[CJ_London]

sorry - in that case I'm out of ideas. Suggest you do further research on the web, perhaps you will find something in other forums or the msdn site. Regret I don't have time to do it for you

 

[spikepl]

I have an idea: sit on this for 2 weeks, due to "higher-priority tasks", and then ask the frequent users again how important it is that some unused rows have some specific colour or other

 

[Leif]

Spikepl,

I agree. If you and CJ London as very frequent posters don't have an answer that probably means there is not an answer. I'll just tell them that is a "feature" in 2010 and to just live with it. Thanks.