Recent content by Degalle

I'm looking at many with additionals. So basically the user will be putting in the data with the colors they select and then it'll automatically set the conditional formatting since that does seem to be the only way. So the answer is for now a lot since I know we will have many companys. I...

So this is in VBA right so my code would be something like this right? Private Sub Form_Load() If Company.Value = "COP" Then Company.BackColor = vbRed End If End Sub I'm still a little lost I guess, do I needing the "If...Then" Statement or is "Value is" it's own built in...

I'm pretty sure this goes in here but if not admins please move to Access General Discussion. So we all know access has conditional formating but it only allows 3 and I've looked all over for any sample coding or anything I could use but it doesn't allow me to change the Backcolor of the...