If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merge to Word
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 |
#2
|
|||
|
|||
Merge to Word
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)) -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Scafidel" wrote in message ... 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 |
#3
|
|||
|
|||
Merge to Word
That's it! I simply plugged in "UCase" and now it's as it should. Thanks,
Arvin. "Arvin Meyer [MVP]" wrote: 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)) -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Scafidel" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|