Combo boxes - different view than value

[Klion]

How do you make a combo box display a list showing items different than the value it actually assigns the choice?

Ie.

Combo Box shows -------- Combobox Interprets this as
----------------------------------------------------------
Test . . . . . . . . . . . . . . . . 1
OtherTest . . . . . . . . . . . . .2
AnotherTest . . . . . . . . . . . 3


Or something more customizeable, ie

Boxshows . . . . . . . . . . . . . . . . . . . . . . . . . ActualFIeldName
--------------------------------------------------------------
Student Identifier. . . . . . . . . . . . . . . . . . . . StudentID
Student's Address . . . . . . . . . . . . . . . . . . . .Address
How long before employment was attained? . . .EmployLength


etc. I seem to remember when helping my friend he accidentally did the first one somehow and because of that his query wouldn't work. The second one I know could be done with VB but I'm wondering if there are options within access specifically for this purpose.

Thanks,

-Klion

 

[Mod]

How do you make a combo box display a list showing items different than the value it actually assigns the choice?

Ie.

Combo Box shows -------- Combobox Interprets this as
----------------------------------------------------------
Test . . . . . . . . . . . . . . . . 1
OtherTest . . . . . . . . . . . . .2
AnotherTest . . . . . . . . . . . 3


Or something more customizeable, ie

Boxshows . . . . . . . . . . . . . . . . . . . . . . . . . ActualFIeldName
--------------------------------------------------------------
Student Identifier. . . . . . . . . . . . . . . . . . . . StudentID
Student's Address . . . . . . . . . . . . . . . . . . . .Address
How long before employment was attained? . . .EmployLength


etc. I seem to remember when helping my friend he accidentally did the first one somehow and because of that his query wouldn't work. The second one I know could be done with VB but I'm wondering if there are options within access specifically for this purpose.

Thanks,

-Klion

In the format properties, make it have two columns. Make the width property something like:
0";1"

a width of 0 makes it hidden.

in the data page of the properties, your row source should be a query selecting the two values, the hidden one first. set the bound column to the hidden column.