Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

option control

ResolvedVersion 2010

Holly has attended:
Access Intermediate course

Option control

When using one or more option button controls, how would you get it to pick either one option, or the other, rather than being able to select both options (Withouth using the option box control)?

RE: Option control

Hello Holly,

Thank you for your question regarding Options.

Unfortunately, the Option Control box has to be used to control the actions of the Option buttons to only allow a single option to be selected. Why don't you want to use the Control box? Maybe make the box transparent if you don't want to see it!

The Option buttons can be controlled without Control boxes, but this requires VBA coding to do this, which is not possible here.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Thu 18 Aug 2011: Automatically marked as resolved.

Access tip:

How To Display An '&' In A Label In A Form

To have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as:

Fox && Hound

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.