Word Merge with ACCESS

S

Sondra

I have a Word Document that I want to merge data from my
Access Database.

The field in my database is a number field ####

The format I would like it to have it show in the Word
Document is CC020-0#-###

Is this possible?
 
P

Peter Jamieson

It should be possible - assuming your field is called mynum, insert a
standard merge field and use Alt-F9 to reveal the code. You should see
something like

{ MERGEFIELD mynum }

Add a numeric format switch as follows:

{ MERGEFIELD mynum \#"0'-'000" }

Assuming the CC020-0 part is constant just put it outside the Mergefield,
e.g.

CC020-0{ MERGEFIELD mynum \#"0'-'000" }

Peter Jamieson
 

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

Top