report field returning data from a lookup rather than table

[JohnLute]

I have a field with this lookup:

SELECT tblUOMLength.txtUOMLength, tblUOMLength.Description
FROM tblUOMLength;

It's bound to Column 2 and displays values like this:
in. | inch

This works fine and "in." is saved properly to the table.

The report field is a simple text box, however, it reports "inch". I'm
stumped. I basically copied/pasted this field from another table where is
also works fine and reports properly. I can't find what the problem is.

Any ideas? Need more info?

Thanks for your help!!!

 

[JohnLute]

DOH!!! I just found my problem. I had the bound column property in the form
field control set to "2" instead of "1".

Thanks!