title: How can I replace a value on an Access 2007 report with an image?
body: <p>I have a colour field in the table I am reporting from. I am intending to replace this text on a report with a small square of colour based on the word.</p>
  
  <p>I have been digging around in Access for days trying to do this and cant seem to find any options in VBA nor the Properties pane.</p>
  
  <p>Updates: Thanks to Tom for pointing me in the right direction, so far I have this sort of working, decided to use a textbox instead of a rectangle as then I can still have the colour text inside. So using the Report_Current event I wrote a huge "Select Case Report_rptSRSearch.Colour" to handle this.</p>
  
  <p>Using the Report_Current event does not seem to give the exact required functionality however. It will do exactly what I want except only when the user physically clicks the record on the report. </p>