Help with Split Form requirement.

[ravikiran]

Hi Access gurus,

I have a very weird requirement in Access.


Please the attached SampleDB, in which a "Release" table is displayed as "Split Form." In this form rather than displaying the values from the table, I am planning to show the form as a Workflow and Status indicator. The fields need to be displayed with relevant status progress indicator (Green, Red, Orange).

SampleDB.zip

I tried with "Conditional Formatting" and am partly successful. However, I am unable to do the following:

• display a "Grey Color" if the Field is "Null" or Blank
• Display "Red Color", if the "Time" field is 2 days less then current date
• Change these fields as Button - (Each of these status should display a different form when clicked. Button is a better display option)

Best if I can achieve these without VBA (I don't mind it as well).


I am sure, you can get some quick tips on these can be accomplished. If possible please let me know how to improvise the design.



Thank you in advance,




Cheers,
Ravi.

[vicsaccess]

Ravi,
null is done with the expression is typed as isnull([status 5])=true
the time field i did with a between set to value is between date() and date()-2
not fully understanding the last part