Results 1 to 5 of 5
  1. #1
    Steve3415 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    3

    Post Conditionally formatting a mm/dd/yyyy*

    I have been asked to easily show the difference between a planned and actual date in a report. The request is to have the planned date show up RED and with and "*" by the date. I have created the expression,



    Planned IR Date*: IIf(Nz([Planned IR Date])=0,"No Date",[Planned IR Date] & "*")

    I have been using conditional format in the report, but cannot this to work yet. By the way, I am a newbie to Access.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why doesn't work - error message, wrong results, nothing?

    Your Nz syntax is wrong, doesn't have alternate value.
    IIf(Nz([Planned IR Date],0)=0,"No Date",[Planned IR Date] & "*")
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Steve3415 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    3
    Quote Originally Posted by June7 View Post
    Why doesn't work - error message, wrong results, nothing?

    Your Nz syntax is wrong, doesn't have alternate value.
    IIf(Nz([Planned IR Date],0)=0,"No Date",[Planned IR Date] & "*")

    Sorry, instead of pasting I typed. It is supposed to be Planned IR Date*: IIf(Nz([Planned IR Date])=0,"No Date",[Planned IR Date] & "*")


    I am using the expression to put an asterisk with the date if the space is Null due to a lack of information. I am not sur what I should be conditionally formatting for. I just know if the cell contains a "5/25/2012*" I want it to be Red. If it is just 5/25/2012 it need to be black.

  4. #4
    Steve3415 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    3
    By the way...

    To date the conditional formatting I have tried has produced nothing. Like nothing happened.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    That is the same expression as the original post and still wrong. Look at my example again. An alternative:
    IIf(IsNull([Planned IR Date]),"No Date",[Planned IR Date] & "*")
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 05-02-2011, 11:02 AM
  2. Replies: 2
    Last Post: 04-20-2011, 01:50 PM
  3. Replies: 12
    Last Post: 03-09-2011, 04:16 PM
  4. InputMask yyyy-mm for Label
    By smaky in forum Queries
    Replies: 5
    Last Post: 11-03-2010, 10:20 AM
  5. Convert to MMM/YYYY
    By Brian62 in forum Queries
    Replies: 10
    Last Post: 08-31-2009, 04:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums