Combo box field in query underlying List box shows ID numbers

L

LVer

I use a combo box from a table in an underlying query for a list box, but in
the list box the ID is shown and not the text. It is a combo box based on a
value list with the folowing structure: 1;"Active";2;"On
Hold";3;"Discharged";4;"Complete". I tried to use the same properties of the
filed in the table to the field in the query underlying the list box, but
everytime I close and save it, the properties have gone.
What am I doing wrong?
LVer
 
D

Dale Fye

LVer,

Is it a combo box, or a listbox, you seem to use these interchangeably?

Both of these controls have the following properties that you need to check:

1. Bound column, this is the column (1 based) that you want to get back
when you reference the value of the control (based on the data you provided,
you probably want to set this to 1).

2. Column Count: set this to 2

3. Column Widths: Set this to 0,1 or some other widths. I don't think
you want to see the numeric value, just the text, so this should work.

HTH
Dale
 
L

LVer

Hi Dale,
Thanks for your response.
I do not use combo box and list box interchangebly though. The list box,
lets call it "Treatments", is based on an underlying query. In this query I
use a field, "ActiveDischarged", from a table called "TblTreatments". The
properties of this field are set to a combo box
(1;"Active";2;"OnHold";3;"Discharged";4;"Complete") in the table as in the
query.
However, every time I close the query and save the changes, the properties
of the field in the query have disappeared when I open the query again.

I hope this cleared things up a bit.

LVer
 
Top