Toggle buttons in form

Hello,
have a form with a option group that contains 4 toggle
buttons. My question is, after i click the button to run a
macro, the button stays as if its Clicked, is there a way
to make the button show as if it hasn't been clicked? Also,
is there a way so that the form doesn't move with the
mouse? Basically, I want the form to appear in center and
don't be moved by dragging the mouse.

Please advise any info, really appreciated.

thanks,

Juan

1. At the end of the Macro, set the value of the OptionGroup to something
different than the 4 values of the 4 ToggleButtons.

2. Set the Moveable Property of the Form to False/No.

--
HTH
Van T. Dinh
MVP (Access)




"Juan" wrote in message
...
Hello,
have a form with a option group that contains 4 toggle
buttons. My question is, after i click the button to run a
macro, the button stays as if its Clicked, is there a way
to make the button show as if it hasn't been clicked? Also,
is there a way so that the form doesn't move with the
mouse? Basically, I want the form to appear in center and
don't be moved by dragging the mouse.

Please advise any info, really appreciated.

thanks,

Juan

Hello Van,
sorry for late reply.
I'm using 97 and I don't see a Moveable property on the
form. There's On Mouse move is there what you mean? Would
I need an Event procedure if so, what would the code be?
Please advise any info
thanks,

juan
-----Original Message-----
1. At the end of the Macro, set the value of the
OptionGroup to something
different than the 4 values of the 4 ToggleButtons.

2. Set the Moveable Property of the Form to False/No.

--
HTH
Van T. Dinh
MVP (Access)




"Juan" wrote in message
...
Hello,
have a form with a option group that contains 4 toggle
buttons. My question is, after i click the button to
run a
macro, the button stays as if its Clicked, is there a
way
to make the button show as if it hasn't been clicked?
Also,
is there a way so that the form doesn't move with the
mouse? Basically, I want the form to appear in center
and
don't be moved by dragging the mouse.

Please advise any info, really appreciated.

thanks,

Juan


.

MouseMove is a different Event. I can't remember exactly but I think
Moveable Property was introduced after A97.

Not sure if there is any other method to besides setting Border Style to
"None" which makes the Window Title hidden and therefore user cannot grab it
to move the Form.

--
HTH
Van T. Dinh
MVP (Access)




"JUAN" wrote in message
...
Hello Van,
sorry for late reply.
I'm using 97 and I don't see a Moveable property on the
form. There's On Mouse move is there what you mean? Would
I need an Event procedure if so, what would the code be?
Please advise any info
thanks,

juan

Hello Van,
yeah, If I do the none border it does work but the form
doesn't look good. Unless I put a borger myself. Was using
the Dialog so was hoping to be able to not move the form
with mouse. Perhaps, on a later day I'll repost see if
anyone has anyother Ideas. You answered my other question
about the toggle, but what about if I'm not using a macro.
This is what I'm doing also:
Have toggle buttons. When I click on one it will open a
form, but the toggle buttons stays clicked, is there a way
that when I click and open the form for the toggle button
to show as Unclick?
I really do appreciate all your input;help you can provide,
thansk,
Juan
-----Original Message-----
MouseMove is a different Event. I can't remember exactly
but I think
Moveable Property was introduced after A97.

Not sure if there is any other method to besides setting
Border Style to
"None" which makes the Window Title hidden and therefore
user cannot grab it
to move the Form.

--
HTH
Van T. Dinh
MVP (Access)




"JUAN" wrote in message
...
Hello Van,
sorry for late reply.
I'm using 97 and I don't see a Moveable property on the
form. There's On Mouse move is there what you mean?
Would
I need an Event procedure if so, what would the code be?
Please advise any info
thanks,

juan


.

YOU referred to Macro in your original post???

Whether you use Macro or VBA in the OptionGroup_AfterUpdate Event, after
your existing code, set the value of the OptionGroup to Null or some value
that is different to the 4 values of the 4 Options. This way, none of the
Options will be shown as "pressed".

--
HTH
Van T. Dinh
MVP (Access)




"Juan" wrote in message
...
Hello Van,
yeah, If I do the none border it does work but the form
doesn't look good. Unless I put a borger myself. Was using
the Dialog so was hoping to be able to not move the form
with mouse. Perhaps, on a later day I'll repost see if
anyone has anyother Ideas. You answered my other question
about the toggle, but what about if I'm not using a macro.
This is what I'm doing also:
Have toggle buttons. When I click on one it will open a
form, but the toggle buttons stays clicked, is there a way
that when I click and open the form for the toggle button
to show as Unclick?
I really do appreciate all your input;help you can provide,
thansk,
Juan