Is it possible to use conditional formatting in Access as you would in Excel?
I have a query that pulls out all the data I need but in the report I list an Over/Short status. I would like to bold/color the result if the item listed is 'short' but be a regular font if it is 'over'.

I am learning TONS just reading through these forums but this is one i haven't figured out yet.

Thanks!

Sure; with the report in design view, select the control you want to format, and select Format/Conditional Formatting.

Sure; with the report in design view, select the control you want to format, and select Format/Conditional Formatting.

you lost me when you said to select the control...
in the report, I have the header, a list of columns, then in the 'data' section there are fields that draw from the query. If I select the "over/short" field here, is that what you mean? Is the format/conditional formatting off of the top file menu?

Sorry... my Access newbieness is showing now :P

By control I mean the textbox or other control you want to apply formatting to. In versions 2000-2003, it is off the top menu. In 2007, it's on the Design tab of the ribbon.

I'm at home now, but when I get to work tomorrow I'll be sure to look this all up and see if i can figure it out.
Thanks a ton!

No problem; post back if you get stuck.

Paul;
Wow; can't believe it was that simple. LoL I guess I should have looked a little harder. I was looking through the properties box for the field; I should have looked across the top!

Let me piggyback though; This worked to highlight that number, but can I apply conditional formatting on field1 per properties of field 2? Instead of just highlighting the one "Negative" number I would like to be able to highlight the entire line. Again, in excel I could just point to the appropriate cell, but not seeing how to do that here.

Thanks again!

Sure; change the first box from "Field value.." to "Expression is", then the expression would be:

[Field2] < 0

or whatever the appropriate expression is.

Perfect. I'm getting smarter by the minute! :cool:

Thanks Paul; just what I needed for this! :)

I wish I could share out this DB and show everyone just how :censored: it is.

How would i apply conditional formatting to strings?

[FieldName] = "String"

[FieldName] = "String"

ty very much!