Only Show Certain Values In ListBox

[GendoPose]

Hi All,

So I have a multi-select listbox with tick boxes and values in on my form. Is it possible to make so only the checked values are showing up and then not display the tick box?

I know I can use a combo box to display several values, but using a listbox like this would be easier on the eye.

Thanks

EDIT; or is it possible to use code to get a text box to show the selected items in the list box?

 

[pr2-eugin]

To start off, you do not have a listbox, but a Multivalue field in the table. This breaks the absolute fundamental principle of DB Design ! I for one despise the use of such fields ! I am not sure if any advanced developers on here would have used it either ! So you might have to resort to something better than a work around ! Good Luck !

 

[GendoPose]

To start off, you do not have a listbox, but a Multivalue field in the table. This breaks the absolute fundamental principle of DB Design ! I for one despise the use of such fields ! I am not sure if any advanced developers on here would have used it either ! So you might have to resort to something better than a work around ! Good Luck !

Ah, woops! That'll be why then! So how would I change this to a proper listbox and then have only the selected values show?

 

[pr2-eugin]

To go to the Form design you first need to fix the table design.

 

[GendoPose]

To go to the Form design you first need to fix the table design.

Ok so I've changed the table design to a listbox, multiple values set at no, but (I should've seen this coming), in my form it won't store the multiple selection of the listbox, is there anyway I can get around this or will it have to be a multiple value field?

After changing it to back a regular single value field, my queries work aagain too, as I would get an error about the JOIN clause not being valid, so I'd rather find a way around this than make it a multiple value field.

 

[GendoPose]

So I think the solution to this will be to properly normalise the data again, but I'm not sure how so I'll start a new thread on the topic and post the information needed