That looks like a lot of code to change the background colour.
You can do it with
Me.fieldname.BackColor = 4033390 'where fieldname is the name of your field
Or you can use
very light green = 7405514
Light green = 6876860
slightly darker = 5950882
Very dark green = 3107669
thank you for your reply. which part of the code i will replace?
Originally Posted by OBP
Posting Permissions
Reply With Quote