General discussion


MS ACCESS Report Problem

By AyukNotna ·
I'm trying to change the VISIBLE property of a TextBox by making expression.

textbox: desc1 */ I use IIF Func to check if
empty or not
textbox: text1 */ if not empty, make visible else
make invisible

the exact expression that I made was

IIF(Desc1 <> null, text1.visible = true, text1.visible = false)

Anybody can tell me what am i doing wrong?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by sgt_shultz In reply to MS ACCESS Report Problem

what happens? nothing? maybe the null is not the only test? maybe test for empty strings ""? if you think this might be the problem there is a good discussion of null in access vb help...

Collapse -

by AyukNotna In reply to

Poster rated this answer.

Collapse -

by kees.valkenswaard In reply to MS ACCESS Report Problem

From your description it is not clear at which moment you want to do the test. This might influence the result as well. Are you testing the .value or .text property?
Anyhow, it should be the empty string you have to test.
Good luck

Collapse -

by AyukNotna In reply to MS ACCESS Report Problem

This question was closed by the author

Related Discussions

Related Forums