Report Showing with Chinese Text

[Tophan]

I have a report which when I open it by clicking the button in the form shows what looks like Chinese text in the memo field. To open the report the following is in the event properties for the referencing button

Private Sub cmdPrintSumReg_Click()
Dim strWhere As String

    If Me.Dirty Then    'Save any edits.
        Me.Dirty = False
    End If

    If Me.NewRecord Then 'Check there is a record to print
        MsgBox "Select a record to print"
    Else
        strWhere = "[ContractName] = """ & Me.[ContractName] & """"
        DoCmd.OpenReport "RPTSmryDwgRegRpt", acViewPreview, , strWhere
    End If
End Sub

When I open the same report from the reports menu on the left of the database it is just fine. But obviously it is showing information for all contracts and not the any one contract.

I haven't changed anything in the table that contains the memo field and this only started happening yesterday afternoon after using this db for over a year.

Any suggestions what might be the problem and how to fix it. I found an earlier post in this forum with a similar problem but the only difference I see is that the user changed the field from a text to a memo. I haven't.

 

[spikepl]

If ContractName is memo then change that to text

 

[Tophan]

Hi

ContractName is not a memo field. It also is not the field that the Chinese text is showing in. The text is showing in a notation field which is supposed to be a memo field.

What I don't understand is when I open the report outside of the form that references the contract it is fine...no Chinese. But info for ALL contracts is showing

 

[vbaInet]

What I don't understand is when I open the report outside of the form that references the contract it is fine...no Chinese. But info for ALL contracts is showing

Don't include the Memo field in a query that has a GROUP BY clause. Group all the fields (except the Memo field), save that query, create a new query based on the grouped query and include the Memo field from the table joined via the ID.

 

[Tophan]

Sorry for not responding sooner - was on vacation !

This worked and the report is no longer showing chinese text.

 

[vbaInet]

Almost a 2 week vacation, nice!