Combo Box Question

R

RobUCSD

I have a combo box with three fields; fldPainID (hidden), fldPainScore,
fldPainScoreDefinition. The fldPainScore has values like; 0,+1, +2, +3, etc.
and the fldPainScoreDefintion has text corresponding to those values
explaining how to score a patients pain. I want the list's width in my data
sheet to be 0.5", just enough to see the fldPainScore values as described
above. But when the user clicks on the combo box I want the user to be able
to see the entire fldPainScoreDefinition in order to aid the user with
choosing the appropriate pain score. I've tried monkeying with the column
width and the list width but can't seem to get it to do what I want. The
fldPainScoreDefinition is 7" long.

Any help would be greatly appreciated. Thanks, Robert
 
R

Rick Brandt

RobUCSD said:
I have a combo box with three fields; fldPainID (hidden), fldPainScore,
fldPainScoreDefinition. The fldPainScore has values like; 0,+1, +2, +3, etc.
and the fldPainScoreDefintion has text corresponding to those values
explaining how to score a patients pain. I want the list's width in my data
sheet to be 0.5", just enough to see the fldPainScore values as described
above. But when the user clicks on the combo box I want the user to be able
to see the entire fldPainScoreDefinition in order to aid the user with
choosing the appropriate pain score. I've tried monkeying with the column
width and the list width but can't seem to get it to do what I want. The
fldPainScoreDefinition is 7" long.

Any help would be greatly appreciated. Thanks, Robert
Click to expand...

The Width property controls how wide the ComboBox is when you are not using it,
but that will have no effect in Datasheet view. In that view the width of the
datasheet column is what dictates the width of what you see when not dropping
the list. The ListWidth property controls how wide the drop-down list is. The
ColumnWidth property controls the width of the individaul columns that you see
when the list is dropped.
 
A

Al Campagna

Rob,
ControlSource = fldPainID
Combo Width = .5"
Columns = 3
Col Widths = 0"; .5"; 7"
List Width = 7.5"

When the combo is dropped down, you'll see the Score (.5") and Definition (7" full
size) but... after selection, the combo closes back to .5, and displays the Score. As you
are probably aware, what's really stored in that control is the fldPainID.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
R

RobUCSD

Perfect, Thanks, Rob

Al Campagna said:
Rob,
ControlSource = fldPainID
Combo Width = .5"
Columns = 3
Col Widths = 0"; .5"; 7"
List Width = 7.5"

When the combo is dropped down, you'll see the Score (.5") and Definition (7" full
size) but... after selection, the combo closes back to .5, and displays the Score. As you
are probably aware, what's really stored in that control is the fldPainID.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
Click to expand...
 
Top