How to Hide Field when null on form

[DaniBoy]

Hello,
I have a form made from a query that has all the fields on the query. I have a drop box to pick the record I want to see. Lets say that I pick the OwnerID#1, and this OwnerID#1 has an address built from this fields:

txtStAddress1
txtStAddress2
txtCity
txtState

now, I want to be able to hide the any field that has nothing on it.

basicly remove or hide the null values and bring the fields up. Trim it. I did use the Can Shrink Can Grow but didnt work!
Thanks Daniel

 

[Rich]

Can shrink/grow apply only when printing,
Me.MyField.Visible=Not IsNull(Me.MyField)

 

[DaniBoy]

Where do I insert this code at?

Thanks

DaniBoy

 

[boblarson]

In the form's On Current event.

 

[SVNTY7]

Will this work on a report

Will the above code work on a report?
I have a field that if 'IS Null' I don't want to be visible
when the report is printed.

Thanks

 

[Rich]

Yes, use the OnFormat event