Conditional Formatting in Forms
in [Forms]
|
From: Judy on 14 Dec 2009 15:50 I'm trying to get a form to display a "Yes" or "No" depending on a review of two dates. Tried a number of times. In English, want it to do the following - if the Date returned to marketing is less than or equal to the due date, write "Yes" and if not write "No" - otherwise leave blank.
From: NuBie via AccessMonster.com on 14 Dec 2009 16:05 ans = iif(dateReturned <= dueDate,"Yes", "No") >write "Yes" and if not write "No" - otherwise leave blank. What instances you want to leave it blank, since date returned equal or less than due date is a "YES", date returned greater than due date is a "NO". Where does the "otherwise leave blank" fits in? Judy wrote: >I'm trying to get a form to display a "Yes" or "No" depending on a review of >two dates. Tried a number of times. In English, want it to do the following >- if the Date returned to marketing is less than or equal to the due date, >write "Yes" and if not write "No" - otherwise leave blank. -- Message posted via http://www.accessmonster.com
|
Pages: 1 Prev: Me.NewRecord and Me.Dirty Next: Complex coding question re: recordset |