I want to format my list boxes so that they are check boxes

[pascaleinlove]

hello,
I am new to Access (I have 2003 version) and I created my table with list
boxes. I was wondering if in my form I could change it to check boxes
instead. I need to be able to multiselect.

I hope I don't need to program anything because I am new to Access. thanks

 

[Stefan Hoffmann]

hi,

I am new to Access (I have 2003 version) and I created my table with list
boxes. I was wondering if in my form I could change it to check boxes
instead.

Can you explain it with more details please?

What table structure do you have (fields, data types, defined lookups)?

I need to be able to multiselect.

Can you explain your concrete problem?



mfG
--> stefan <--

 

[Arvin Meyer [MVP]]

Have a look here:

http://www.lebans.com/vb_listbox.htm

Stephen Lebans built a VB type listbox that has checkboxes.

 

[John W. Vinson]

hello,
I am new to Access (I have 2003 version) and I created my table with list
boxes. I was wondering if in my form I could change it to check boxes
instead. I need to be able to multiselect.

I hope I don't need to program anything because I am new to Access. thanks

Grumble grump. I am probably just being an old fogy here but...

Tables DON'T CONTAIN LISTBOXES.
Tables DON'T CONTAIN CHECKBOXES.
Tables DON'T CONTAIN COMBO BOXES.

Tables contain *data* - numbers, text, dates, etc.

Listboxes, checkboxes, combo boxes, even textboxes aren't data; they are *data
display tools*. They make a lot of sense on a Form, the preferred tool for
interacting with data. Tables should ideally be hidden, under the hood,
invisible to users; the user should see just the Form. On a form you can use
any appropriate type of control (a checkbox, listbox, whatever) bound to the
data in your table; you can even have different forms with different controls
for the same data, if you wish.