colour formatting for Reports

[chriswatson78]

Hi, (Please forgive any stupidity in the next few lines, I am a novice and new to this forum)

I am a self taught Acces user so have no knowledge of technical jargon. My problem is I am trying to run a report with numerical data. I want the numerical data to appear as a different colour depending on the value. In forma I can do this very easily using code if [form]![Numerical_value] = <5 then Numerical_value.forecolour = green for example.

However I do not seem to be able to replicate this in a report, I have three criteria, less than 5 = red, greater then 50 = blue, and anything else remains black.

I have a work around which is splitting the query upon which the report is based into three and creationg three value boxes pastedon top of each other, however this does not export to MS Word very well as I see all the underneath results.

Does anyone know how I can have my one query (which returns numerical values 1-100) but show the values as different colours in the report which I can export to Word aslo?

I would havbe thought it would be easy but the programming for Forms seems to be different for Reports

Any help would be greatly appreciated

 

[Oldsoftboss]

You should be able to do this on a report. Try putting the in Detail_Format

Dave

 

[sdawson]

In design view, right click on textbox and choose "Conditional Formatting".
This allows up to 4 conditions with different colour backgrounds or text (or both). My problem is I need more!