Text Box with if statement

[Arrrggggjhhhhh!!!!]

Hi, Not sure if this is OK but...

I am inserting a text box onto a form which will show the text "Bonus Due" if a date in another text box (called text43) matches todays date. If it doesn't match todays date then the text just says "No Bonus due".

I thought using an IF statement would do this.

Does anyone have any suggestions. I did try this....

=if([text43]=Date(),"Bonus Due","No Bonus Due")

It doesnt work.



Anyone know why please?

[pbaldy]

For starters, it's IIf, not If (If only works in VBA code). If it still doesn't work, is it possible the textbox has a time component in it?

[Arrrggggjhhhhh!!!!]

Many thanks. Sorted!!! I've also passed on this to another user who had a similar issue so its two birds with one stone!!

[pbaldy]

Happy to help!