Numbers displayed instead of text (1 Viewer)

aattas · Feb 11, 2019

Experts,

1- I have a table that has 4 columns
2- I used a field in a form to locate the second column and insert into the filed.
3- The i created a unbound field to display the third column as Description.
4- the unbound displayed properly as per the table (3rd Column).
5- when i created the query for the main filed, it comes out numbers instead of text as in the form.

Any ideas why did happen.

Muchas Gracias

isladogs · Feb 11, 2019

You are using words like fields and columns incorrectly within the context of Access tables and forms. This makes it hard to understand your meaning.

Tables have fields. Forms have controls that may be unbound or bound to fields.

Gasman · Feb 11, 2019

Sounds to me like you are getting the ID of the combo (2nd column) and not the description (3rd column)

Combos start at 0 as well, so 3rd column is column(2)

HTH

aattas · Feb 11, 2019

gentlemen,

Thankyou for your reply.

Isladogs, you are right , thanks for pointing out. I took a note.

Gasman, thanks for the reply.

I think i found my problem, you guys are my inspiration.

The problem was in the Bound Column, it was 1 and when i changed to 2, all text appeared.

Thanks again guys.

Gasman · Feb 11, 2019

I always have my combos set up as

First field is the bound field and normally the ID of the record. Always hidden.
Next field is the descriptive field
Any others follow on after.

theDBguy · Feb 11, 2019

Hi. I hope I’m wrong, but it sounds to me like you’re using a lookup field at the table level. If so, be careful. You could be in for some more headaches down the road.

Numbers displayed instead of text (1 Viewer)

aattas

Registered User.

isladogs

MVP / VIP

Gasman

Enthusiastic Amateur

aattas

Registered User.

Gasman

Enthusiastic Amateur

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread