Jump to content

Access Question

Gary P

Recommended Posts


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.





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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...