Look up function is returning a number instead of name.

[Rickster172]

I have setup a field to lookup a name for a location when I do something with
this field it returns a number instead of a name. How can I correct this?

 

[Douglas J. Steele]

Congratulations. You've found yet one of the many reasons why many of us
abhor that misguided "Lookup Field" misfeature. (For some of the other
reasons, see http://www.mvps.org/access/lookupfields.htm at "The Access
Web")

You'll need to join your table to the lookup table in order to get the
description.

 

[Dominic Vella]

You need to set the first column width to 0 length. This will cause the
first width to be invisible and the 2 column to be displayed at the default
width.

Eg, if I have a lookup for a table with an ID and a name, I would put column
count to 2, bound column to 1 and column widths to 0.

I hope this helps.



Dom
www.effectivedata.com.au

 

[Iwona Michalczyk]

ala mode