A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Check Box properties



 
 
Thread Tools Display Modes
  #1  
Old December 14th, 2006, 09:59 PM posted to microsoft.public.access.forms
Mike
external usenet poster
 
Posts: 2
Default Check Box properties

I need to make a check box visible/invisible according to a user
selection from another combo box.

I have used this in the past, CheckName of checkbox.visible = false
and on running a database that I created about three years ago this
works fine.

However implementing the same thing in a new database I am constructing
gives a 'Run Time Error '424' Object required, using the same syntax.
Labels I am using work correctly with labelName of label.visible =
false, its just check boxes I am having a problem with.

I am now using Access2002 (10.6771.6817)SP3 and Win XP Pro
The other database was constructed in Access 2000 and Win2000 Pro but it
runs and performs correctly on the new system. I am only getting this
error in the new database.

Thanks in anticipation
regards
Mike
  #2  
Old December 14th, 2006, 10:05 PM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Check Box properties

Can you give an example of exactly what you mean by "CheckName of
checkbox"?


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Mike" wrote in message
. uk...
I need to make a check box visible/invisible according to a user selection
from another combo box.

I have used this in the past, CheckName of checkbox.visible = false and
on running a database that I created about three years ago this works
fine.

However implementing the same thing in a new database I am constructing
gives a 'Run Time Error '424' Object required, using the same syntax.
Labels I am using work correctly with labelName of label.visible =
false, its just check boxes I am having a problem with.

I am now using Access2002 (10.6771.6817)SP3 and Win XP Pro
The other database was constructed in Access 2000 and Win2000 Pro but it
runs and performs correctly on the new system. I am only getting this
error in the new database.

Thanks in anticipation
regards
Mike



  #3  
Old December 14th, 2006, 10:12 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Check Box properties

You don't use the word Check or Label in your statement.
Always qualify the control with the name of the form or if you are working
within the current form, you can use either Me. or Me!

Me.chkAnyName.Visible = False

"Mike" wrote:

I need to make a check box visible/invisible according to a user
selection from another combo box.

I have used this in the past, CheckName of checkbox.visible = false
and on running a database that I created about three years ago this
works fine.

However implementing the same thing in a new database I am constructing
gives a 'Run Time Error '424' Object required, using the same syntax.
Labels I am using work correctly with labelName of label.visible =
false, its just check boxes I am having a problem with.

I am now using Access2002 (10.6771.6817)SP3 and Win XP Pro
The other database was constructed in Access 2000 and Win2000 Pro but it
runs and performs correctly on the new system. I am only getting this
error in the new database.

Thanks in anticipation
regards
Mike

  #4  
Old December 15th, 2006, 07:45 PM posted to microsoft.public.access.forms
Mike
external usenet poster
 
Posts: 2
Default Check Box properties

Klatuu wrote:
You don't use the word Check or Label in your statement.
Always qualify the control with the name of the form or if you are working
within the current form, you can use either Me. or Me!

Me.chkAnyName.Visible = False

"Mike" wrote:


I need to make a check box visible/invisible according to a user
selection from another combo box.

I have used this in the past, CheckName of checkbox.visible = false
and on running a database that I created about three years ago this
works fine.

However implementing the same thing in a new database I am constructing
gives a 'Run Time Error '424' Object required, using the same syntax.
Labels I am using work correctly with labelName of label.visible =
false, its just check boxes I am having a problem with.

I am now using Access2002 (10.6771.6817)SP3 and Win XP Pro
The other database was constructed in Access 2000 and Win2000 Pro but it
runs and performs correctly on the new system. I am only getting this
error in the new database.

Thanks in anticipation
regards
Mike

Thanks Klatuu
It worked OK when I just used the name of the checkbox and I wonder why
this has not come up before as I did not have any problems before using
the check[checkboxname] format.
I have not used Me. or Me! I am working within the current form so is
it important to always qualify the control in this way?
  #5  
Old December 15th, 2006, 08:14 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Check Box properties

Although, as you have seen, you can get away with it in most cases, it is a
really good idea to qualify the references so there will be no confusion.

"Mike" wrote:

Klatuu wrote:
You don't use the word Check or Label in your statement.
Always qualify the control with the name of the form or if you are working
within the current form, you can use either Me. or Me!

Me.chkAnyName.Visible = False

"Mike" wrote:


I need to make a check box visible/invisible according to a user
selection from another combo box.

I have used this in the past, CheckName of checkbox.visible = false
and on running a database that I created about three years ago this
works fine.

However implementing the same thing in a new database I am constructing
gives a 'Run Time Error '424' Object required, using the same syntax.
Labels I am using work correctly with labelName of label.visible =
false, its just check boxes I am having a problem with.

I am now using Access2002 (10.6771.6817)SP3 and Win XP Pro
The other database was constructed in Access 2000 and Win2000 Pro but it
runs and performs correctly on the new system. I am only getting this
error in the new database.

Thanks in anticipation
regards
Mike

Thanks Klatuu
It worked OK when I just used the name of the checkbox and I wonder why
this has not come up before as I did not have any problems before using
the check[checkboxname] format.
I have not used Me. or Me! I am working within the current form so is
it important to always qualify the control in this way?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.