Weird OrderBy problem

[elsandalos]

Hi all,
Found a weird problem when editing records in continuous form view (and datasheet view) when a particular memo field is being used by OrderBy to sort the data. When i have just created a new record and tab to the next record, the record i was just in jumps to the top of the records, but in its place is an exact copy of the record above. Very confusing, and looks like a redraw bug but it happens on all PCs.

What happens is ... (letters relate to records going down the screen)

A
B
C
D ....new record being entered then <TAB> and ...

D ....has jumped up here
A
B
C
C ....duplicate of C - but duplicate record never created in the table
E ....new record

When i quit the form and come back in, everything is ok

As far as i know, OrderBy only takes effect if you refresh the form (which i'm not doing). It works fine if i take off OrderBy, or if i use another field with OrderBy. So is there some problem using OrderBy with a memo field, and how is this making my records jump about?

help!

Pete

 

[elsandalos]

To illustrate this problem, i've attached someone else's example db for sorting which i took off another thread. I wanted to check if my db was corrupt or something. Anyway, all the fields in the Employee table were text, but i changed one (Full Name) to memo, and sure enough, this db now has exactly the same problems as mine.

Click on the Full Name heading to sort by that column, scroll to the bottom, enter data in the blank record and then tab into the next new record and see what happens. Then click on any of the other column headings (all text fields) and add a new record - it works fine.

any ideas?

El.