Corrupted Records?

[Paul Fenton]

We have a front end/back end application (Access 2k) which contains a
table of client sales records, including date of sale and amount of
sale. We run various sales reports off this table.

While running the report for October '05 sales, we noticed that it
would hang on "formatting page..." until we did a CTRL-BREAK. We've
discovered that anytime we include the date of October 8th, the report
will fail. There are 2 records that have a sale date of Octiber 8th.
I can run the report from 10/1 to 10/7 or 10/9 to 10/31, no problem.

We've compacted and repaired with no success. The records don't look
any different than many others.

Suggestions?


Paul Fenton
(e-mail address removed)

 

[Guest]

There might be some non-displayed characters. Try copying the raw data and
Paste Special - Values in Excel. Then copy and paste back in Access.

 

[Paul Fenton]

One of the fields in the record is a Memo field. I discovered that if
I delete all the text in those fields, the problem goes away and the
report prints. I copied and pasted the text into Word and don't see
anything unusual about it. It's 1500 characters or so.


Paul Fenton