P
plh
How can I make a conditional statement in a text box? I have a recollection of
using "iff" but it does not seem to be working.
Right now I have
=[txtSize]/25.4
in text box "txtImpEquiv".
This is of course to give the Imperial equivalent of a metric value in txtSize.
I want to make this conditional on the value of "chkMetric", a check box.
If chkMetric = -1, I want to show the value, if not, I want a blank cell.
I tried =iff[chkMetric=-1,[txtSize]/25.4,""] but Access says this contains an
invalid syntax.
Thanx,
-plh
using "iff" but it does not seem to be working.
Right now I have
=[txtSize]/25.4
in text box "txtImpEquiv".
This is of course to give the Imperial equivalent of a metric value in txtSize.
I want to make this conditional on the value of "chkMetric", a check box.
If chkMetric = -1, I want to show the value, if not, I want a blank cell.
I tried =iff[chkMetric=-1,[txtSize]/25.4,""] but Access says this contains an
invalid syntax.
Thanx,
-plh