Form BackColor

[Dick7Access]

I have goggled until I have run out of googlies<G>

I am trying to change form backcolor with a cmd button via VBA.

What's a simple code?

Thanks in advance.

Nice to be able to come to here when I run out of other options!




















A

 

[Mile-O]

You're looking for the Detail.BackColor property.

 

[gemma-the-husky]

yes, note also that the form actually has different sections, that can have different colours

Forms("test").Section("detail").BackColor = whatever

 

[Thales750]

Dick, a google is 10 to the 99th are you quite sure you are already running out?

 

[Dick7Access]

Dick, a google is 10 to the 99th are you quite sure you are already running out?

love it. well, maybe I exaggerated a little.
thanks to all.

 

[Dick7Access]

yes, note also that the form actually has different sections, that can have different colours

Forms("test").Section("detail").BackColor = whatever

thanks worked great, but "whatever" was a terrible color, I used vbGreen instead.

I wonder why I didn't bring any of that code info up after 999,999,999,999,999,999 goggles.

 

[gemma-the-husky]

thanks worked great, but "whatever" was a terrible color, I used vbGreen instead.

I wonder why I didn't bring any of that code info up after 999,999,999,999,999,999 goggles.

I don't much care for vbGreen.
I used to use white on red, and white on blue, but on some monitors they are hard to read, so I tend to use black on yellow now for the most part.