Question Datasheet Colouring

[burrelly]

Is it possible to colour differnt rows in data sheet view different colours the way you can in excel?

If so it is possible to do it via conditional formatting depending on a drop down in one of the cells?

 

[wazz]

pretty sure it's all or nothing. you can change the entire background but not 'cells' or rows.

 

[gemma-the-husky]

the thing is Access (and other databases) deal with set theory - your datasheet is a set (collection) of data satisfying certain criteria, and therefore there IS, per se, no logical distinction between the rows that Access can use intrinsically to affect the colouring

I presume MS realised this was a practical issue, and partially solved it by offering the 'limited' conditional formatting, but this applies to continuous forms only, rather than datasheets, I think. Conditional formatting has the appearance (to me) of being a bolt on addition, rather than a native feature.

the thing is, in a spreadsheet, the colouring isnt really an attribute of the data, its an attribute of the row or column - if you do this in a spreadsheet, the colouring is valid only for a certain order - if you reorder the xl sheet, the colours will become meaningless.

Now Access deals with columns fine - its all based on columns (fields), but it doesn't really understand rows (without user stipulation, the data is just presented in any arbitrary order).

 

[tmd_63]

There is no way to colour the cells/rows in true datasheet view.
But.
You can use the standard view and set the text boxes to look like a datashhet view and colour them there.

 

[Dennisk]

Alternate row colouring comes as standard in Access 2007 and I've seen fudges from Access 97 upwards. I'll try and find one. Or in Access 2000 if you add an extra column to your table which would be the background to the row, and use conditional formatting.

Create a static function with one variable and call that in the query that drives the form. Inside the function return 0 then 1 then 0 ... then use tthat value as the condition.


this may help


http://www.databasedev.co.uk/alternate_row_colours.html