Datasheet background

[captnk]

Is it possible to change the underlying color (the grey/black) under a datasheet.

Note: Not the datasheet itself

 

[Jack Cowley]

In a word, nope... That, I believe, is up to Windows....

Jack

 

[captnk]

Tks Jack.
I was afraid that would be the answer

Captnk

 

[MM-UK]

Right click the desktop
Goto display properties
If on XP goto advanced

Change the "Application Background"

This will do the trick

 

[captnk]

MM-UK
U r a genius
Tks heaps mate it works great

Captnk

 

[Jack Cowley]

Pat to the rescue! Once again I have learned something that I did not know you could do. Thanks Pat!

Jack

 

[moori]

Hello,

I stumbled across this pretty old post and have some questions about it. I hope anyone still reads this ;-)
If I alter my display properties, then the color change will only appear when I open the database on my computer, right? The rest of my users will still have the original color set by Microsoft?
And the "Me.DatasheetBackColor" doesn't change the Background, but the color of the cells. I'd like to use it anyway, but what kind of color code is used here?

Thanks for any hints,
moori

 

[Simon_MT]

Don't, Never use Datasheets but a Continuous Form. You can format a Continuous Form to look like a Datasheet and then you Format the background for each row or add Alternative rows. I now have no Datasheets.

I should add a provsio: I'm using Access 2007 and previously Access 1997 so I don't know what happens with the intervening versions.

Simon

 

[moori]

Hm, this possibility never crossed my mind... but you're right, that would be more flexible!
Thanks!

 

[Simon_MT]

It took me a while for the penny to drop. Another thing you can do with one-to-many situations is create a query using the 'bottom' information and the 'top' information in the Header. The transaction information is the Detail acts the same way as a subForm and the Header the Parent.

I discovered that row formatting isn't available for Datasheets so bye-bye Datasheets.

Simon

 

[martinhough]

Actually, in Access 2007 you can change the colour of datasheets (forms or subforms - background) by right clicking on the datasheet in question. Select 'Datasheet' and you'll be presented with a dialogue box with cell colours/grid-lines and effects options.

 

[spikepl]

Totals row works also in A2007

There is another neat trick that I gleaned from one of the templates on the MS site: Use a split form, but shrink the detail section to 0. This, effectively, yields a data sheet with a header section.