Hi,
I have an Access 2010 database that contains addresses that I use for generating invoices.
I got an order from Cyprus today and the address is in Greek.
I can save the record ok with the Greek characters but when I open the report to print the invoice the Greek characters show as question marks.
I use a module to clean up addresses, I'm not really a programmer and I scavanged the code for it off the internet.
The code is pasted below.
From what I can gather I may need to use Microsoft Forms 2.0 Object Library. I can find the dll for it, but how do incorporate into my code or database?
If anyone's got any idea's please help!
Public Function formatAddress(v1, v2, v3, v4, v5, v6, v7)
Dim output As String
Dim addressArray(7) As String
Dim i As Integer
addressArray(1) = v1 & ""
addressArray(2) = v2 & ""
addressArray(3) = v3 & ""
addressArray(4) = v4 & ""
addressArray(5) = v5 & ""
addressArray(6) = v6 & ""
addressArray(7) = v7 & ""
i = 1
For i = 1 To 7
If (addressArray(i) = "") = False Then
output = output & addressArray(i) & vbCrLf
End If
Next
formatAddress = output
End Function