Bound Text box and Tables, Queries and Reports???

[csegal]

I have a text box labeled "ALERT" based on a calculated
text box labeled "DAYS TO GO" the formula for the alert box:
=IIf([Days To Go]<31,&quot;* *ALERT* *&quot;,&quot; &quot
the formula for the days to go box:=[Cal Due Date]-Date().
Days to go is based on a text box labeled &quot;CAL DUE DATE&quot;
cal due date is based on a text box labeled &quot;INTERVAL&quot;
The formula for cal due date:=[Cal Date]+[Interval]
How everything works is: when a tool is calibrated, the new date is entered into the text box &quot;CAL DATE&quot;.
The cal due date is automatically calculated based on the &quot;INTERVAL&quot;.
The &quot;ALERT&quot; comes up in the form text box if the &quot;DAYS TO GO&quot; box indicates less than 31 days to go.

My problem is that the word &quot;ALERT&quot; is not showing up in the report or the table or the query???
I hope I gave enough information.
I can be reached at
csegal@fineair.com

 

[JoeMiller]

Did you try performing the calculation directly in the field instead of referencing the control, like this:

=IIf([Cal Due Date]-Date()>31,&quot;**ALERT**&quot;,&quot;&quot

HTH
Joe Miller
joe.miller@flotech.net