How to change Records Colors in every new month based on date using vba? (1 Viewer)

Local time
Today, 22:59
Joined
Dec 18, 2021
Messages
46
Hi everyone!

I have long records entered in one year and I need to change the background color of records entered every month based on date entered. I need just 2 colors alternatively between months no more.
I need to do that on subform in the Form.
Thanks for any help.
 

Gasman

Enthusiastic Amateur
Local time
Today, 20:59
Joined
Sep 21, 2011
Messages
14,047
Divide the month by 2.
If int() of the result is equal result, use one colour, else use the other.
 
Local time
Today, 22:59
Joined
Dec 18, 2021
Messages
46
Divide the month by 2.
If int() of the result is equal result, use one colour, else use the other.
Thanks for the quick reply but sorry I couldn't apply it. I need more details in example.
Your answer will be greatly appreciated.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:59
Joined
May 7, 2009
Messages
19,169
open mainForm
close the form.
open sfBankActivity form in design view.
select all textbox.
on menu->format->conditional format, and see the formatting.
 

Attachments

  • alternateColor.accdb
    512 KB · Views: 249

Users who are viewing this thread

Top Bottom