merging with access database

[wendy]

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

 

[Peter Jamieson]

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.

--
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?