Hi all,
I am using the following code to put data from a textbox (text8) in my Access form into a Form Field in a word template called "Discipline":
Set oApp = CreateObject("Word.Application"
oApp.Visible = True
oApp.Documents.Add Template:="C:\Worksheet.dot", NewTemplate:=False
oApp.ActiveWindow.WindowState = wdWindowStateMaximize
oApp.ActiveDocument.FormFields("Discipline".Result = Me.Text8.Value
doc1 = oApp.Application.Caption
The problem I am having is that I have the EnterKeyBehaviour property of the text box as New Line in Field, but when I export a multi-line piece of text to the word document, it gives me a rectangle at the start of each new line.
Does anyone know how to get rid of it?
Thanks,
Joe
I am using the following code to put data from a textbox (text8) in my Access form into a Form Field in a word template called "Discipline":
Set oApp = CreateObject("Word.Application"
oApp.Visible = True
oApp.Documents.Add Template:="C:\Worksheet.dot", NewTemplate:=False
oApp.ActiveWindow.WindowState = wdWindowStateMaximize
oApp.ActiveDocument.FormFields("Discipline".Result = Me.Text8.Value
doc1 = oApp.Application.Caption
The problem I am having is that I have the EnterKeyBehaviour property of the text box as New Line in Field, but when I export a multi-line piece of text to the word document, it gives me a rectangle at the start of each new line.
Does anyone know how to get rid of it?
Thanks,
Joe