merging with access database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wendy - 20 Apr 2004 01:41 GMT

I have a form document in Word that I am tyrying to merge with an Access database. In Access, I have a state field with a ">" in the format properties box so that all the two-letter abbreviations are capitalized. When I merge the two together, the states come out lowercase though they appear uppercase in the table because of the properties setting.

Why does this happen and how can I changee it without going back and retyping all of the states in uppercase

Thanks

WEND

Reply to this Message

Peter Jamieson - 20 Apr 2004 08:40 GMT

It happens because the formatting properties you define in Access are only
really honoured by Access. It will store your data as lower case. Other
applications will get this data "directly".

In this case, one way to get what you want is as follows:

In Word, use Alt-F9 to reveal the "field codes". You will probably see
something like

{ MERGEFIELD myfield \*Mergeformat }

Change this to

{ MERGEFIELD myfield \*Upper }

(or perhaps

{ MERGEFIELD myfield \*Upper \*Mergeformat }

)

Press Alt-F9 again to reveal the field results.

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I have a form document in Word that I am tyrying to merge with an Access database. In Access, I have a state field with a ">" in the format

properties box so that all the two-letter abbreviations are capitalized.
When I merge the two together, the states come out lowercase though they
appear uppercase in the table because of the properties setting.

> Why does this happen and how can I changee it without going back and retyping all of the states in uppercase?
>
> Thanks.
>
> WENDY

Reply to this Message