Unbound OptionGroup Enabled

[Tony_VBACoder]

Does anyone know if there is a workaround to having an
Unbound Option group (frame) on a Form be enabled when the
Form's .AllowEdits property equals False?

On my form, I have an Unbound Frame titled "Print Option"
where I have 3 choices: 1) Preview 2) Printer 3) PDF.
When my form loads, I set the Form's .AllowEdits property
based on the CurrentUser, whose ID determines if they have
Read-Only or Write permission. But it appears that when I
set the .AllowEdit property, all the data controls on the
form become disabled, including my Unbound Printer frame,
which I would like to enabled so the user can choose their
Print method. However, buttons on the form do not become
disabled.

 

[Graham Mandeno]

Hi Tony

Unfortunately, AllowEdits affects all editable controls, whether or not they
are bound. A bit silly really, IMO, but there you have it.

There are two workarounds I can think of OTTOMH:

1. Instead of setting AllowEdits = False, set all the bound controls Locked
= True.

2. Put a transparent command button over each of the option buttons, with a
click event to set the option group to the appropriate value. Command
buttons cannot be bound and are therefore not affected by AllowEdits.

 

[Tony_VBACoder]

Thanks for the reply.

BTW...what does IMO and OTTOMH stand for?

-----Original Message-----
Hi Tony

Unfortunately, AllowEdits affects all editable controls, whether or not they
are bound. A bit silly really, IMO, but there you have it.

There are two workarounds I can think of OTTOMH:

1. Instead of setting AllowEdits = False, set all the bound controls Locked
= True.

2. Put a transparent command button over each of the option buttons, with a
click event to set the option group to the appropriate value. Command
buttons cannot be bound and are therefore not affected by AllowEdits.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Does anyone know if there is a workaround to having an
Unbound Option group (frame) on a Form be enabled when the
Form's .AllowEdits property equals False?

On my form, I have an Unbound Frame titled "Print Option"
where I have 3 choices: 1) Preview 2) Printer 3) PDF.
When my form loads, I set the Form's .AllowEdits property
based on the CurrentUser, whose ID determines if they have
Read-Only or Write permission. But it appears that when I
set the .AllowEdit property, all the data controls on the
form become disabled, including my Unbound Printer frame,
which I would like to enabled so the user can choose their
Print method. However, buttons on the form do not become
disabled.

.

 

[Graham Mandeno]

Thanks for the reply.

You're welcome. I hope one of the solutions does the trick for you.

BTW...what does IMO and OTTOMH stand for?

In My Opinion and Off The Top Of My Head.

What does BTW mean <only kidding>