Can we put condition in source expression of textbox?

bhagyesh

Hello All,
I want to know can we put conditions(IF...then..else) in "source expression" property of a textbox in a subform.???

Marije_Brummel

No.

Instead you can use the returnvalue of a function and put your conditions there.

David_Singleton

Just make life simple for everyone, and explain what you are trying to achieve. ](*,)

snehalppatel

Mark is right...Create a function in table/form/request form, where you want to use the value of condition. Take the return value from function using Exit(Value), and in the Source Expression of the textbox, put the name of the Function with parenthesis e.g. FunctionName().