General discussion

  • Creator
    Topic
  • #2298061

    MS ACCESS Report Problem

    Locked

    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?

    Thanks.

All Comments

  • Author
    Replies
    • #2744374

      Reply To: MS ACCESS Report Problem

      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…

    • #2744340

      Reply To: MS ACCESS Report Problem

      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

    • #2744332

      Reply To: MS ACCESS Report Problem

      by ayuknotna ·

      In reply to MS ACCESS Report Problem

      This question was closed by the author

Viewing 2 reply threads