Sorting in forms and reports differ

S

Sascha Hennig

hi.

i have a form and a report based on the same query. i can filter and sort
the records in the form and then open the report and the filter
configuration is applied in the report because i give the vba code on
opening the report:

myReport.Filter = myForm.Filter
myReport.FilterOn = True
myReport.OrderBy = myForm.OrderBy
myReport.OrderByOn = True

but special characters like quotes are sorted differently in the form and
the report. the sorting of the form ignores quotes (only the first
alphanumeric character decides about the sorting) and the sorting of the
report interpretes them like characters and sort differerent because of
this.

but i need an equal order in both! what can i do?
 
Top