title: Setting Access Colour Codes in VBA
body: <p>I'm having trouble setting the back ground colour of a textbox in my Access database. I want to change the colour to red when certain conditions are met.</p>
  
  <p>In design view I've set the textbox's back color property to red and it is shown as '#ED1C24'. When I view the form in Form view the control is correctly shown in the red colour I've chosen.</p>
  
  <p>But when I put this value into my VBA code (Text1.Backcolor = "#ED1C24") I get a type mismatch error. </p>
  
  <p>I've tried changing it to a Hex number (Text1.Backcolor = &amp;HED1C24) but then the control turns blue.</p>
  
  <p>Any help would be appreciated. Thanks.</p>