>In some grids I can reproduce it. what happens is that when resettng the controlsource, it kind of shifts and the data is not anymore aligned to the columns. This happens by itself without doing anything except set RecordSource = "" and then filling again the original recordsource, even if the cursor itself has not changed at all.
>
>See Screenshot, above before, below is after resetting the recordsource.
>
>This happens only with grids that have a lot of functionality.
In your example, the first date is first displayed as date, then as datetime; the first time is displayed as time, then as "memo". So there was some extra code handling that which didn't fire when you reset the recordsource.