Hi Everyone,

I have created a fairly regular form that shows a number of data fields across the form with the standard text box object. What I would like to do is set the color of the text and/or the back ground when a certain condition applies.

For example, is the value is positive, black text on a white background. But if the value is equal to zero, lets show the text in red. Maybe red background, with white text?

I have tried using the format property on the text box as you would in MS Excel. eg: "#,###;[red]-#,###"

This does not do the same thing as Excel, but that is the sort of thing I'm hoping to achieve.

Any ideas folks?

TIA

Alan

Use Format > Conditional Formatting on the text box.

Set Default Formatting to black text on white background.

Then set the Condition 1 to Field Value Is, and then Equal To, or Less Than, and then enter "0" (for Equal To) or "1" (for Less Than [integer]). Then set your formatting to Red background, white text, maybe bold, etc.

I use conditional formatting on reports as well.

I hope this helps.



mmcdonal

Hi,

Thanks for this. Perfect!

Never looked for this on the menus, no wonder I didn't find it!

(Wonder what else I'm missing out on?)

Alan

I'm trying to mimic conditional formatting in an Access Project using VBA.

(if I do try to use the actual conditional formating with an ADO recordset in the clas module of the report, it seems to crash the project, so I'm looking for alternatives)

I suppose I'm uncertain how Reports iterate through a recordset. Is one referance to a text box sufficient to apply the formatting OR do I have to iterate through different instances of that control?