Auto Format Date Fields in Form

T

TotallyConfused

I have a form that has 3 date fields. Sent Date, Due Date and RCVD Date. I
have been piecing this together and am not sure if I have what I need. If
this can be condensed? Or expressions in Conditional Formatting be nested.
I would appreciate any help you can provide as I am truly Totally Confused on
this one.

I Currently, have the following:
For Sent date field I have on Click event enters Date() and adds a due date
to the Due Date Field
For Due Date field I have in Conditional Formatting expression is
NZ([RCVDDate]),"")="" turns font red
Due Date field in Conditional Formatting expression is ([RCVD DAte])
Is not Null turns font grey
For RCVD date I have on Click event enters Date()

What I need is:
Sent Date field on Click enters Date() and adds a due date to the Due Date
Field.
For Due Date field I want Due Date to turn red if RCVD Date is Null and Due
Date is past date in Due Date. If there is a date in RCVD Date, then I want
Due Date and Sent Date to be greyed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top