Word/Access merge with column based on lookup

[petermeachem]

Helping out someone here.

They are trying to do a word merge from an access table. The town column is a lookup from the town table (Select id,town from town. Bound Column 1, column widths 0cm, 4cm). So the town field is text and appears to contain the town name but when you use it as a merge field Word picks up the id instead.

Is there any way round this, or do I have to drop the lookup in the table.

TIA

http://www.therockalltimes.co.uk/

http://english2american.com/

And particularly

http://www.therockalltimes.co.uk/2003/03/10/war-warning.html

 

[cjkoontz]

Does the mergefield look something like this?

{MERGEFIELD TOWN}?

What happens when you click the View Merged Data button (<<<ABC>>>)?

 

[petermeachem]

If it is either {MERGEFIELD TOWN} or {TOWN}, the data is a number when in Word.

http://www.therockalltimes.co.uk/

http://english2american.com/

And particularly

http://www.therockalltimes.co.uk/2003/03/10/war-warning.html

 

[cjkoontz]

Hm.

The only thing that I can think of is that you need to reexamine the lookup table for TOWN in your Access file. Do you have it pointing back to the TOWN field or ID field?