Setting visible property on a report field

tnzabo · July 21st, 2005, 10:55 AM

I would like to set a report field to visible or not depending on another field in the detail layout. I'm not sure of the syntax of the VB code. Here is what I have now and it's not working. I'm doing this on the OnPrint event of the detail.

IIf (Me!txtPrevInv Is Null), (Me!txtShipPer.Visible = False), (Me!txtShipPer.Visible = True)

Any help would be great!!

Thanx - tnzabo

dartcoach · July 21st, 2005, 11:14 AM

Try this:

IIf (isnull(Me!txtPrevInv), (Me!txtShipPer.Visible = False), (Me!txtShipPer.Visible = True)

Kevin

dartcoach

tnzabo · July 21st, 2005, 11:28 AM

You are kidding me! It worked beautifully - syntax is so picky. Just by moving the is null. Great! Thanks so much!

nikkiz

dartcoach · July 21st, 2005, 11:30 AM

No problem.
Thanks for posting that you got it resolved.

Kevin

dartcoach