Toggle button vs Command button

  • Thread starter Thread starter Steve Stad
  • Start date Start date
S

Steve Stad

I was using command buttons to write text in a text box. The command buttons
work fine. I was thinking of using toggle buttons because toggle buttons
change color/shading when pressed. The toggle button writes the text in the
box but I get a 'Run-time error '2115' - The macro or function set to the
BeforeUpdate or ValidationRule property for this field is preventing dbname
from saving data in the field. END/DEBUG. I am using the 'OnClick' Event
to write the text. Do I need code in another event?

Private Sub Toggle21_Click()
HelpWindow.SetFocus
HelpWindow.Text = "Writes this text"
End Sub
 
On Fri, 28 May 2010 07:14:01 -0700, Steve Stad

This may be related to trying to set the focus at an inopportune time.
Fortunately it is not necessary, if you replace your two lines with:
HelpWindow.Value = "Hello World"
(.Text requires the control to have focus; .Value does not)

-Tom.
Microsoft Access MVP
 
Thanks Tom,

This (your) code works fine for the toggle buttons. i.e., I removed the
..setfocus line.
Private Sub Toggle23_Click()
HelpWindow.Value = "CTR Rule - toggle button"
End Sub
.....
Is there a way for a toggle button shading to change from pressed to
Unpressed when another toggle button is pressed. Right now each toggle
button is highlighted as pressed unless you press it again.
 
Back
Top