Hide a text box

[Mike Powell]

Hi all,

I have a db, and in my table |I have a collect and deliver field. This follows through a quary, a form for inputting addresses, and onto a report that I use as an order. The Collect and Delivery addresses appear when necessary. What I want to do, is only have the delivery text box on the report page, if there is data in the delivery field. No delivery address, no text box.

Any idea's

Mike

 

[bjackson]

use the on print event for the detail
that the text box appears in

if isnull(me![thetextboxname]) then
me![thetextboxname].visible=false
else
me![thetextboxname].visible=true
end if

 

[Mike Powell]

Thanks for the reply,
I'll give it a go !!

Mike

 

[ghudson]

bjackson,

Exactly what I was looking for!

Thanks!!!

 

[Mike Powell]

Keeps comming up with a " missing endif" error.

Mike

 

[bjackson]

Mike
the code i have sent has no extra or missing if statements

do you have any other code in that particular
event procedure

what does the debug highlight when you get the error
have you compiled the code?