I want to display a word but do a calculation the result

  • Thread starter Thread starter KevinS
  • Start date Start date
K

KevinS

I have a form that has a drop down for how the customer felt the service was.
I could make my life wasier by changing everything to a number but let's say
that's not posiible.

The drop down says
Strongly Agree (which has a value of 5)
Agree (whcih has a value of 4)
Neutral (which has a value of 3)
Disagree (which has a value of 2)
Strongly Disagree (which has a value of 1)

I would like to show the words but do a calculation on the average number of
responses. Is there a way to show one thing to the user and another to the
field for calculations?

Hope this makes sense.
 
Yep.
A Combo or ListBox can have multiple columns but hide some.
Properties --
Column Count - 2
Bound Column - 1
Column Widths - 0"; 1.5" ---- as wide as you need the text display
Control Source - Your number field
 
Just to expand a little on what Karl has said;

If the values you listed are the only values that you are going to have in
your combo box then you can change the Row Source Type property of your combo
box to "Value List" and then type in the values, including the number you
want for each option in the Row Source property. Like this:

5;Strongly Agree;4;Agree;3;Neutral;2;Disagree;1;Strongly Disagree

Then by using the settings that Karl has already talked about, you can
display the Text value but the combo box will store or hold the numeric value
in column 1.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
 
Back
Top