Option control

Resolved · Low Priority · Version 2010

Wed 10 Aug 2011, 16:08 Delegate Holly said...

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)?

Fri 12 Aug 2011, 09:38 Trainer Mark said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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