Sort number and letter combinations in a form in datasheet view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have asked this question about reports and received a very satisfactory
reply. However, I need the same function in a report in datasheet view but
the sorting and grouping option is not available in form design.

In the form I want to see a list of all the "structures" I have in place and
in some instances I will want to view the list by "ID No." and in some
instances by "area" (area = position). The "Area" field contains plain
numbers and numbers with letters, e.g. 20, 21b, 67, 105a, 105d, 127. I want
the list sorted by area to come up in that order, but the sort
asceding/descending in form design comes up with numbers only first followed
by number/letter combinations.

"ID No." contains alphanumerics, but with an input mask. The input mask
always uses the same letters as a prefix, followed by 4 numbers. The numbers
are input by the user.

If this requires visual basic code, please don't assume I know anything
about commands and/or syntax because I don't. I need you to be gentle with
me and explain carefully so that I don't make a mistake.

Thanks to any brainboxes out there who can help.

Crazy Lady
 
you can set the form's OrderBy property. in the Properties box in form
design view, click in the Order By "field" and press F1 to see the Help
topic.

or you can base your form on a query, and set the sort order in the query's
design view.

in either case, you should be able to duplicate the sorting that you used in
your report. the Grouping and Sorting dialog in a report lists the fields
"vertically", sorting by the top field first, then the next field, etc. a
query, or the form's OrderBy property, sort "left to right", sorting by the
left-most ordered field first, then the next, etc.

hth
 
Back
Top