Drop Down Menu problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick - 11 Aug 2005 18:31 GMT

I am using Microsoft Access 2002 and Word 2002. I keep trying to do a mail
merge but I keep getting numbers where drop down menus are in the tables. For
example if there is a list of 4 options to choose from, in the mail merge on
word, a number is given, not the option you choose. What do I have to do to
get the option to show up instead of a number.

Reply to this Message

Doug Robbins - 11 Aug 2005 20:49 GMT

Use a query in access that returns the data that you want and use that as
the datasource for the mailmerge.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am using Microsoft Access 2002 and Word 2002. I keep trying to do a mail
> merge but I keep getting numbers where drop down menus are in the tables.
[quoted text clipped - 4 lines]
> to
> get the option to show up instead of a number.

Reply to this Message

Nick - 12 Aug 2005 15:19 GMT

That didn't help at all. I still get the numbers appearing. Some of my
co-workers said it might be something with a look up number. The way I
understood them was that all the dell's that were chosen in the drop down are
all 12. That is true also. So all the same numbers are suppose to be showing
the same thing 12 = dell, 10 = IBM and so on.

> Use a query in access that returns the data that you want and use that as
> the datasource for the mailmerge.
[quoted text clipped - 7 lines]
> > to
> > get the option to show up instead of a number.

Reply to this Message

Doug Robbins - 12 Aug 2005 20:58 GMT

It seems like in the Access Database, the Row Source Values for the Lookup
are defined in the design of the table and it is the numbers that are being
stored, not the associated text. What you will need to do is create a
separate table that contains one field with the numbers and another with the
text that is associated with each number. Then you can use a select query
in which the two tables are linked by the fields that contain the numbers
and you can have the appropriate text value appear for each record.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> That didn't help at all. I still get the numbers appearing. Some of my
> co-workers said it might be something with a look up number. The way I
[quoted text clipped - 19 lines]
>> > to
>> > get the option to show up instead of a number.

Reply to this Message