Parry IT Support

VBA Colours

If Side = "MS" Then Me.Detail.BackColor = vbMagenta 'Changes to PINK  

' In the example above, If a form field called side = MS then change the form background to PINK

RGB Colours

Sub Form_Current() 

     Dim lngGreen As Long 

     lngGreen = RGB(60,179,113) 

    Me!txtPastDue.BorderColor = lngGreen 

    Me!txtPastDue.ForeColor = lngGreen 

    Me!txtPastDue.BackColor = lngGreen 

End Sub

Links

• https://docs.microsoft.com/en-us/office/vba/api/access.textbox.backcolor
• https://www.rapidtables.com/web/color/
• https://www.engram9.info/access-vba-programming/changing-colors.htmlhttps://www.engram9.info/access-vba-programming/changing-colors.html