Software

Ask something
Discussion Locked

MS ACCESS Report Problem

0 helpful
4 replies

by ayuknotna

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

Thanks.

4 replies

by sgt_shultz

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...

by kees.valkenswaard

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

This discussion is closed to new replies.