List Box

[onropjack]

I am doing data imput in a table. I want to be able to click a list box and
have words come up but when i select on of these words i just want a single
value to appear. Is it possible?

 

[Duane Hookom]

You should be doing data input into a form based on your table. You would
have many more options available.

Can you explain what you mean by "have words come up"?

 

[onropjack]

for example, when i hit the arrow to have my list box come up i want the
phrase, "Pension". When i select the word pension i want "1" to be listed.
This is so i cat print 1 instead of the word pension.

 

[Duane Hookom]

Hit what arrow? What do you mean by "come up"? Where/what are you printing?
Where do you want "1" to be "listed"?

 

[onropjack]

I am in a table. I formated a list box field in my table. When i bring up
the list box in the database view of my table phrases, that i imputed, appear
such as pension. When i select pension i do not want pension to appear on
the table rather i would want a number corrosponding to pension to appear. I
would like this because it saves space. The number is a reference for the
word pension.

 

[Duane Hookom]

1) try to not use tables for data entry
2) avoid using lookup fields in tables
http://www.mvps.org/access/lookupfields.htm
3) a combo or list box on a form can be set to display one
value but store another value. This is set with the
bound column and column widths properties.