Visibile property

M

m stroup

rpt_Events
chkstatus (Check box)
txtLabel1 (text box)

Detail_Format...
If chkstatus then
me.txtlabel1.visible = false
End If

I am trying to add this code, but in vba, I do not get the option to add
..visible to the control. When I type this code in by hand, it states "you
have entered an expression that has no value".

I have tried Reports!rpt_Events!chkstatus as well.

Any suggestions? thanks in advance.
 
D

Duane Hookom

I would doublecheck the spelling of your text box name. Are both the
chkStatus and txtLabel1 in the detail section?

If you copied your code, I would expect Me. to be capitalized.

You should also have code to set the txtLabel1 visible if there is more than
one record in the report. I would actually use code like:

Me.txtLabel1.Visible = (Me.chkStatus = False)
 
M

m stroup

Thanks Duane,
That worked. I don't understand why the help isn't working. i.e. I type
in me.txtLabel1. and I should get visible as an option. I do not. So I
thought that was the issue. The real issue was a mispelling.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top