Customized Checkboxes (1 Viewer)

[waleedimtiaz]

Hi everyone, I am new to MS Access. I just wanted to whether I can make my own Data checkboxes under a specific field.
In Access there is only Yes/No check boxes, I did use one approach by declaring Data as Fields and used Yes/No check box for each field. But I think this not the right way to do it. Is there any option in Access to create multiple checkboxes under a specific field. For example, as given below:
I want to make a Field in the table named "Unsafe working conditions", and beneath that I want all these data checkboxes in datatypes rather than Yes/No.

 

[CJ_London]

a control is only one thing - a textbox, a checkbox, whatever, it can't be both. So seems to me

declaring Data as Fields and used Yes/No check box for each field.

is the right way to go.

Access does have what is called a multi value field, but 99% of developers wouldn't recommend it as a way to go. Lots of reasons why, you can google to find out more.

Usual method is to use a subform and select the required workplace conditions

 

[waleedimtiaz]

a control is only one thing - a textbox, a checkbox, whatever, it can't be both. So seems to me



is the right way to go.

Access does have what is called a multi value field, but 99% of developers wouldn't recommend it as a way to go. Lots of reasons why, you can google to find out more.

Usual method is to use a subform and select the required workplace conditions

What I did is, I separately declared the data values as fields and selected the type for each field as "Yes/No" checkbox, then when I make a form I get these data values as check boxes.

 

[theDBguy]

Hi. I think what you want can be done using a Multi-Value Field. However, that comes with its own set of issues. If you use them, you'll have to know what you're getting into.

 

[MajP]

Faking a Multi Value Field

I have seen a few posts lately on people wanting to use multi valued fields. Most Access developers steer away from them and build their own related tables. Although they are properly normalized and work well, they can get very confusing even if you know the ins and outs. I wanted to see if I...

www.access-programmers.co.uk

 

[ebs17]

Jean Pierre Allain showed the following solution to MS ACCESS: Data maintenance of m:n records via checkboxes

MS ACCESS: Datenpflege von m:n Datensätze über Kontrollkästchen

Office Tipps und Tricks VBA Programmcode Access Excel

msofficeinside.blogspot.com