I know that right now a form set for tabular view has the background of each record alternating between light and dark.
My question is this. Can I set the background of each record to the same color?
Thanks for any help you can give me.
Dave
I know that right now a form set for tabular view has the background of each record alternating between light and dark.
My question is this. Can I set the background of each record to the same color?
Thanks for any help you can give me.
Dave
Try setting the Detail section AlternateBackColor property.
Ooops, just tested and that does not work with Datasheet view. Probably have to use Continuous view and arrange controls to look like datasheet.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks very much it solved the problem
It was under the property of the background; under detail; and Alternate background set to "No Color"
Thanks again June7 I just couldn't find out where to look.
Now Happy days are here again.
Dave
datasheets use different properties based on columns and rows rather than controls and sections and only available via vba - see this link
https://docs.microsoft.com/en-us/off...sheetbackcolor
you may have to set both back and alternate colors
Interesting, tried that and doesn't work for Datasheet view.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
it works for me - in form open event
Me.DatasheetBackColor = vbRed
Me.DatasheetAlternateBackColor = vbGreen
bit garish but it works
but either way, looks like OP is not using a datasheet anyway