Expression build resetting function

[Guest]

Hello,

I have a nested user define function in the Expression Build of a report.
The simple funtion works, but when I place a IIF() around it, Access does not
save the new logic and keeps doing a save as with the old logic. Is this to
complex for Access or am I doing something wrong???? Thanks in advance for
you help.

Current Working Function in Expression Builder used on a Unbound Field in a
Report:
=CalculateBuyOrSellDate([PayDate],[SellDay]))

New logic that Access will NOT save:
=IIF( IsNull([SellDay], " ", CalculateBuyOrSellDate([PayDate],[SellDay]))

What I wish to do is check for Nulls. If there is a Null, the print
nothing, otherwise, call the function I wrote and print the result.

- Mike P

 

[Marshall Barton]

Hello,

I have a nested user define function in the Expression Build of a report.
The simple funtion works, but when I place a IIF() around it, Access does not
save the new logic and keeps doing a save as with the old logic. Is this to
complex for Access or am I doing something wrong???? Thanks in advance for
you help.

Current Working Function in Expression Builder used on a Unbound Field in a
Report:
=CalculateBuyOrSellDate([PayDate],[SellDay]))

New logic that Access will NOT save:
=IIF( IsNull([SellDay], " ", CalculateBuyOrSellDate([PayDate],[SellDay]))

Other than a missing right parenthesis, it looks ok to me.

 

[Guest]

The code is syntacily correct, yet failed to work and was reporting a
"Invalid Control Property: Control Source"

To make this work I had to create another unbounded text box, the type the
functions manually in. If I used the Add Existing Functions or the Expersion
Builder, it would not work. This workaround worked fine.

Thanks - Mike