Hide object based on Yes/No field

  • Thread starter Thread starter adna
  • Start date Start date
A

adna

Hi,
I want to hide an object on a report if the value of the yes/no text box =
no or 0
I keep getting an error "you entered an expression that has no value"
What am I doing wrong?

Here is my code from reports event Open:
If Me.txtcheckbox = "0" Then
Me.objectOne.Visible = False
End If
 
It's 0 (or False), not "0"

Even simpler would be:

Me.objectOne.Visible = Me.txtcheckbox
 
Douglas,
Thanks for your reply
I tried your code below and got another error:
Runtime error 13
Type mismatch
 
I think I found out what was causing the problem. I had the code in the
Report Open Event but after moving it to the OnFormat Event of the detail I
no longer get the errors.
 
You must log in or register to reply here.

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

Similar Threads

YES/NO FIELD IN COMBOBOX 6
yes/no for old data 4
Hide Fields on Reports based upon criteria 4
Trapping Enter Key No Longer Working 4
Access Table Yes / No Field Question 4
Yes/No field 1
HELP WITH TAB CONTROL - HIDING FIELDS 7
Excel Is it possible to ask a question within a question? 0

Back
Top