Field dispalys ID instead of data

G

Guest

I have a report that utilizes a field from a query, that field is a look-up field. In the table and queries the data displays just fine, but in the report the ID number displays rather than the actual data. Example: I want AZ to show, but instead it shows 1 or if I want CA to show it shows the ID 3. How to I get it to show the data rather than the ID number? Thank you for your help!
 
R

Ragnar Midtskogen

You can use a combobox and set the RowSource to the table for the lookup
field.
If you create the report in design view, when you drag the ID field onto
your report, Access will make the field a combo automatically.

Ragnar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ID number showing 1
One to Many Relationship 2
ID field shows instead of text 1
Report showing ID numbers only 1
Display only some fields from each record based on specific criter 7
Access Access Report Works on One Machine but not Another 3
Show text instead of ID 4
Count funtion in report-I'm too rusty! 1

Top