Value according to date

[Tony McGuire]

Hi,
I have among others 3 fields on a form:
1. <Date> (current date)
2. <DueDate>
3. <Amount>



As a default I want the <Amount> value to be shown as $0.00 until the <Date> is = or > than the <DueDate> then I would like the <Amount> value to reflect its true <Amount> for example $20.00.Can anyone provide me with a VBA syntax to make this work?
Tony McGuire

[pbaldy]

For display? How about

IIf(Date() >= DueDate, Amount, 0)