Cannot alphabetically sort a combo box by display text in report

[Guest]

I am unable to alphabetically sort a combo box header in a report; the sort
keeps defaulting to the underlying numeric lookup field. Although the report
does display the correct linked text, it sorts by the number field which is
related to the text in the linked table relationships.

I have troubleshooted the orderby property (it is correct) as well as the
sort order of left to right. (the linked numeric field is not assigned a sort
property, but neverless the database keeps sorting by the associated lookup
number field and not by the text field it is linked to).

I have exhausted all of the FAQ options.

Does anyone have an idea of how I correct this sort problem.

 

[John W. Vinson]

I am unable to alphabetically sort a combo box header in a report; the sort
keeps defaulting to the underlying numeric lookup field. Although the report
does display the correct linked text, it sorts by the number field which is
related to the text in the linked table relationships.

This is one of the many, many reasons that serious developers dislike the
Lookup Wizard. Your report DOES NOT CONTAIN the text. It contains a number,
because that's what's in your table!

Rather than putting a combo box on the report, base the Report on a Query
joining your main table to the lookup table. Select the text field from the
lookup table, and use IT in the Sorting and Grouping dialog of the report and
as the control source for a report textbox (not a combo box).

John W. Vinson [MVP]

 

[Guest]

Thanks kindly. I reworked the report right after I sent this post...and it is
now sorting properly.