ActiveX Check Box - Groups w Only one Value Allowed

[BrianFawcett]

I am designing a form that will be used for new orders for my team, and I have a series of check boxes I need to create on the form. I have created ActiveX checkboxes, and assigned them to Groups through the Properties.

But the groups are stil alllowing multiple values (boxes) to be selected.

How do I set the groups so that only one value can be selected?

[tigeravatar]

BrianFawcett,

Welcome to the forum. For what you're describing I'd recommend using Option Buttons instead, since only 1 should be allowed to be selected at a time per group.

~tigeravatar

[BrianFawcett]

I looked into that but I was unable to reformat the Option Box, i.e. remove the text and border on the box.

Is it possible to reformat the Option Box?

[BrianFawcett]

I really don't like that way that looks on my form.

How do I set up the ActiveX controls the way I would like to.

[romperstomper]

Optionbuttons are designed to work the way you want; checkboxes are not. By using checkboxes in a way that users are unfamiliar with, you will be more likely to confuse them.

Other than being round, there isn't really much difference in the look of the two so I'm not sure what you are having an issue with?

[BrianFawcett]

Romperstomper,

My issue is with the box itself. I have a form designed already and don't really want to mess with it too much.

My issue is with the way the box looks. I don't want to see the box itself or the text that goes with it.

Is there a way to do this?

[romperstomper]

Oh, I see - you mean the Frame/Group Box. You don't need that if you use the ActiveX versions - just set the GroupName property of all the optionbuttons you want grouped to the same thing (e.g. Group1, Group2 etc)

[BrianFawcett]

I was able to do that, but how do I set it up so that only one of the options can be chosen?

[romperstomper]

If you use Optionbuttons that is the default behaviour.

[BrianFawcett]

Romperstomper, I realize that I find myself it a catch-22 situation. The Option box does what I want but I don't like the look of it.

The ActiveX looks right, but I cannot seem to get it to only choose one option.

Which one of the issues is easier to resolve?

[romperstomper]

With the option buttons you do not need a box around them, as I said.

[BrianFawcett]

How do I get rid of the box??

[BrianFawcett]

Romperstomper,

Maybe I am missing something, but if I use the options buttons without the Options Box, it does not limit me from choosing multiple items.

[romperstomper]

You have to set the GroupName property as I mentioned. See attached.

[BrianFawcett]

Thanks so much for your help.

[BrianFawcett]

Romperstomper, I have one follow up question. I have set up my boxes and the groups. What I want to do is set them so that no one them are chosen when you open the form. how do i do this?

[romperstomper]

In Design Mode you can set the value of all of them to False.

[BrianFawcett]

I have an unrelated Excel question.

I have some fields on the report where I want the user to only be able to input certain formats (i.e. dates).

How do I set this up?

[romperstomper]

Can you post that as a separate question, please and please mark this thread as Solved?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save