Don't calculate when opening form

[acarterczyz]

Hi guys,

My issue is this:
My form consists of a bunch of text boxes that calculate off of one text box (only one you can edit) at the top of the form. My problem is, whenever I enter this form, it will attempt to calculate all the fields (which takes a good deal of time) when there is nothing imputted in the field at the top for it to calculate off of. Is there any way I can tell these fields not to calculate until something is entered into the top field?

Not sure if that makes any sense - its Monday.

 

[boblarson]

How are the calculations set? Are they set as an expression in the control source? If so, you could do this:

=IIf(Len([FieldNameHere] & "") = 0, 0, {Put The Calculation Expression Here})

You should be able to substitute NULL for 0 to return if you wish that instead.

 

[acarterczyz]

How are the calculations set? Are they set as an expression in the control source? If so, you could do this:

=IIf(Len([FieldNameHere] & "") = 0, 0, {Put The Calculation Expression Here})

You should be able to substitute NULL for 0 to return if you wish that instead.

Perfect!! Thank you!!