Fixed it!
It was because it was using itself in the expression so I just done some extra text boxes with the original data, but turned visible to no in the properties. Thanks again!
Thanks for your help. I tried putting that in the control source but now it just shows #error. I tried it directly as it is as well as "" instead of null. Any more ideas?
I've possibly not explained myself properly or should've started a new thread instead of hijacking this one.
There are a series of projects and once the project ends they should develop action plans for the future. These need to be monitored quarterly over the following 12 months. In my table...
Is there any way to do this where instead of hiding the text box when the field is empty, to hiding it when a date falls outside of a set range? I've tried changing it using 'Between' and with < and > but I keep getting errors.
The reason for this is I've got information under 4 different...