G
Guest
i have a form and a report that use the same query as source. in the form i
can sort the records and this order is applied to the report too by using
vba:
MyReport.OrderBy = MyForm.OrderBy
MyReport.FilterOn = True
but the order is not applied exactly. in the form quotes are ignored, but in
the report they are used to sort.
order in the form:
"abc"
bcd
order in the report:
bcd
"abc"
numerical characters are handled different as well. ones they are in front
of the remainder and ones at the end.
what can i do to make the sorting equyl in form and report?????
can sort the records and this order is applied to the report too by using
vba:
MyReport.OrderBy = MyForm.OrderBy
MyReport.FilterOn = True
but the order is not applied exactly. in the form quotes are ignored, but in
the report they are used to sort.
order in the form:
"abc"
bcd
order in the report:
bcd
"abc"
numerical characters are handled different as well. ones they are in front
of the remainder and ones at the end.
what can i do to make the sorting equyl in form and report?????