Solved Form calculation IIF? (1 Viewer)

[GC1]

Good Day,

I have a form which has a calculation however I only want the calculation to calculate when another text box has a value. At present when the form is loaded the calculation completes without there being a value.

The calculated field (RemainingLife) is based on this

([installdate]+[indicative date]) – [CurrentYear]

Installdate is manually entered however when this is blank the calculation completes which is messy. I would like this calculation (RemainingLife) to only complete when install date has a value.

I have tried a combination of iff statements with IsNull, IsEmpty but I just can’t seem figure this one out.

=IIf(IsEmpty([txtInstallDate]),"",([txtInstallDate]+[txtIndicativeLife])-[txtCurrentYear])

=IIf(IsNull([txtInstallDate]),"",([txtInstallDate]+[txtIndicativeLife])-[txtCurrentYear])

Any assistance would be greatly appreciated.

Thanks

 

[theDBguy]

Looks to me like the second one should work. If the textbox is not null but empty, you might try checking for both. For example:

=IIf([txtInstallDate] & ""="","",YourFormulaHere)

 

[GC1]

Looks to me like the second one should work. If the textbox is not null but empty, you might try checking for both. For example:

=IIf([txtInstallDate] & ""="","",YourFormulaHere)

Thank you theDBguy, your code has worked, much appreciated

 

[theDBguy]

Thank you theDBguy, your code has worked, much appreciated

You're welcome. Good luck with your project.