Access Question

[Gary P]

Guys,

I've got an Access project that has certain fields that would create data with negative numbers (showing customers that are above a credit limit, etc...) Is there and kind of IIf statement I can write that would make those numers red, or is that an Excel-only type function?

 

I was thinking something like IIf([expression name]<0,color=Red,color=Black) but that isn't the correct syntax and I'm not sure what to use, if it's even possible.

 

Thanks,

Gary

 

Edit:I went through the report builder module and was able to set up some conditional formatting which worked nicely. However, if I use the File>Send to>Mail Recipient command (trying to make it easy for the person who will actually be running this report) it loses said formatting during the export, so that doesn't do much good.

[JoeyN]

I used to be very good at Access , as i used it a lot in HS and College. Wrote a few programs with it for a final project. Haven't use it in years though, but I may still have one of my books for it. Ill see if i can find anything for you