hi,
in your form's initialization sub, add code to set each option button to
true or false;
example:
me.optionbutton1 = true
me.optionbutton2 = false
and so on.....

Regards
FSt1

"Ram" wrote:

In my excel form I have a few options with (Yes, No) as answers. For
which i have used Option button. On completing this form I have a
command button, on clicking the command button the form is attached to
a mail with to address as our depts mail id. How ever the glitch is
when we recieve the form and open it the dots in the option buttion
vanish. What can i do to fix this.

Thanks for your help.