option control

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Option control

Option control

resolvedResolved · Low Priority · Version 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:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips


Server loaded in 0.1 secs.