You are here:

Using MS Access/Access 2007 labels feature


I have created a labels report on Access 2007 based on a query but for some reason the "Journal Title" field keeps returning the original ID# from my original table, instead of the text from the report which is what I want displayed (see red highlights).  Please note I am sending an image from my home computer which only has Access 2000, so that is why the difference, but the problem exists on both.  How can I get the labels to display the same text (Journal Title) which is shown on the "Find duplicates for RECEIVED..." query?

Hi Brian,

Many thanks the question.

I could not see an uploaded image, so not sure what happened to it.

So I am taking a punt here.

The most likely problem is that the field you are using on the report, is a lookup field (i.e. drop down box), that displays the Journal Title, thus it is linked to the underlying table and this is done by the ID field.  Thus why the ID field is displaying.

You can solve this problem, by adding the table that has this data in it.  Then adding the 'real' journal title, to your query.

Hope this makes sense.  If not, or if it does not solve your problem, try uploading the image again.


Using MS Access

All Answers

Answers by Expert:

Ask Experts


Julie Misson


My area of expertise is Microsoft Access 2000-2007. I have been building microsoft databases for the past twelve years. I would be competent in answering questions from novice Access 2000 users to the more advanced including VBA. If I cannot help, I am more than likely be able to point you to websites that can.


I have a Microsoft Access business where I build database for small businesses. These are usually one off designs, where there is no off the shelf software avaliable to meet the business needs. I also teach Microsft Access to beginners. I am the owner of the website.

Self taught in Microsoft Access. Have done some units in normalisation and SQL, but most of what I know I have learnt from books originally and more recently the Internet.

©2017 All rights reserved.

[an error occurred while processing this directive]