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

 

[Pat Hartman]

You can do it with code. I use this in the open event of a datasheet subform:

Me.DatasheetBackColor = 10481661

There are a number of Datasheet properties that can be changed from code but not thrugh the GUI. Search help.

 

[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.

 

[Pat Hartman]

I use datasheet format whenever I can for subforms. I never use datasheets as main forms. If I want my main form to be a datasheet, I create an unbound form and plop the datasheet subform on it. That way I have headers and footers and places to put buttons.

The datasheet format gives you some unique features.
1. columns can be sized
2. column order can be altered.
3. in A2010 (and possibly A2007) totals rows can be added with no code by simply pressing the sigma button in the ribbon and choosing the way you want to aggregate each column. This is of course not as flexible as doing it yourself but it is still quite useful.

When you work with forms in datasheet view, you need to understand how they actually work in order to not let them defeat you. The primary issue is captions. If you create the form yourself and you create captions in the header and have only the controls in the detail section, Access will use the column name from the query as the caption no matter what you do (unless you go back to the table and add captions). So use the technique that the wizard does which is to create the form in single view so that each bound control has an associated label. Then you can change the values in the labels and that will change the captions. If you want to change the column order, move the controls around on the form and before you save, press the TabOrder option on the ribbon and set the tab order.

 

[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.