 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / May 2006Reset an Option Button to False?
I'm trying to reset an option button back to false in Access 2003. I've tried things like: Me!optTitle.Value = False optBlockTextTitle.Value = False optBlockTextTitle = Null These all result in: Run-time error 2448: You can' assign a value to this object. Any clues greatly appreciated! Donald > I'm trying to reset an option button back to false in Access 2003. I've tried > things like: [quoted text clipped - 10 lines] > > Donald What do you mean by 'back to false'? Do you mean remove any selected button value? What's the name of the Option Group? Is it "optTitle" or "optBlockTextTitle"? Me![NameOfGroup] = Null works for me.  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail I tried your code, and both your options worked Does the option button is bounded to a field in a table? It could be that you can't update this field SignatureGood Luck BS"D > I'm trying to reset an option button back to false in Access 2003. I've tried > things like: [quoted text clipped - 10 lines] > > Donald Thanks fredg & Ofer, It's an unbound button, not part of a group. There it a case when the button is selected (true) by the user, I need to change it back to false. I goofed pasting in the code-it's only one button, should all be the same name. Me!optTitle.Value = False optTitle.Value = False optTitle = Null > I tried your code, and both your options worked > [quoted text clipped - 15 lines] > > > > Donald Thanks for confiirming the code works, I was going in circles with this. I moved it to a different place in the code and it works now (?). > Thanks fredg & Ofer, > [quoted text clipped - 25 lines] > > > > > > Donald |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.