Hello, back for some help.
I am having problem when exporting data to Word. On my form ( records source is Table1), I have a textbox (Amounte), with format Euro and decimals as Auto. When I type or open the form, the value in textbox Amounte is displayed correctly (ex. €100.50). When I export to Work, in the document, I will get only 100 (without the decimals).
I understand that Access reads the machine currency setting, but just cannot find a solution. I need this control to be left as currency as it is also used to perform calculation. Thank you
I am having problem when exporting data to Word. On my form ( records source is Table1), I have a textbox (Amounte), with format Euro and decimals as Auto. When I type or open the form, the value in textbox Amounte is displayed correctly (ex. €100.50). When I export to Work, in the document, I will get only 100 (without the decimals).
I understand that Access reads the machine currency setting, but just cannot find a solution. I need this control to be left as currency as it is also used to perform calculation. Thank you
Code:
On Error Resume Next
Dim objWord As Object
Dim strPath As String
strPath = DLookup("[TemplateLocation]", "TablePath", "[TemplateID]='" & Me.[txtMyWordFile & "'")
Set objWord = CreateObject("Word.Application")
objWord.Visible = False
objWord.Documents.Add strPath
objWord.ActiveDocument.Bookmarks("Amounte").Select
objWord.Selection.Text = me.Amounte
objWord.Visible = True