Results 1 to 2 of 2

Thread: Sorting (2003)

  1. #1
    New Lounger
    Join Date
    Sep 2006
    Thanked 0 Times in 0 Posts

    Sorting (2003)

    I have a form -- default view: single form -- that I've sorted by a source field -- order by: tbl.[field]. This works to sort the forms, but it does so in ascending order, and I need it to go backwards. There's no sort by (AZ) buttons in the form design view. Is there any way I can do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Sorting (2003)

    The best way to sort the records in a form is to create a query that sorts the data in the desired order, and to use that query as record source of the form.

    You can set the Order By property of the form in design view, and add a space followed by the keyword DESC (for descending) after the field name, but there is no guarantee that the form will actually be sorted according to this specification.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts