Merge to Word

[Guest]

I saw a similar post, but I am using the method described in "MS Office 2000
Automation" help files to Merge an Access Form with a Word document that has
bookmarks. It works ok, but none of the commands on the form, i.e.,
capitalize, display 4 decimals, comes out in the Word document. State shows
up as la instead of LA as on the form. I am able to control some of the
formatting with the bookmarks like Fonts, but not this. I am new to Access
and any help would be appreciated.
Thanks
Scafidel
Lafayette, LA

 

[Arvin Meyer [MVP]]

More than likely you need to validate or use Input masks to control the way
data is entered. It is simply sloppy data entry to use la instead of LA. You
can use Update queries to fix a lot of existing data. For instance:

UPDATE MyTable SET MyState = UCase(MyState);

You can also control how data is entered in the Bookmark. Look at the code
at:

http://www.datastrat.com/Code/WordMerge.txt

One of the entries could read:

.ActiveDocument.Bookmarks("State").Select
.Selection.Text = UCase(CStr(Me.txtState))

 

[Guest]

That's it! I simply plugged in "UCase" and now it's as it should. Thanks,
Arvin.