Record Keeps Getting Corrupt

Question

A record I use frequently keeps getting corrupt.

The field is a 'Long Text' set to 'Rich Text'

Every month, like clockwork, when I try to print the record the text in the report preview is white, the same as the back color.

The report itself is ok. The only way to correct it is to delete the record and add the text back into the.

I can copy and paste the text to WordPad and print it out it's fine.

Any help will be appreciated,

James

Answer 1

It may not be corruption. Rich Text formatted with html tends to be idiosyncratic.

Answer 2

OK. I'll see how it goes.

The only thing that bothers me is that no other record in the table gets corrupted like this.

Answer 3

That makes sense, yes.

Because Rich Text does accept html codes to control things like font size and style and color, it is easy to imagine that something in the text needs to be managed directly in the report to render properly.

Out of curiosity, the grocery list never changes?

Answer 4

At the table level the field Append Only is set to No.

This is happens every month.

I open this record using the Where NoteItem="GroceryList"

It seems to change the forecolor of the text in print preview to white.

The table is a notes table with 3 fields: NoteID, NoteItem and NoteDetails. NoteDetails is the one getting corrupted.

I have 2 reports for this data. The one that keeps getting corrupted is a Grocery List which I have the text set to a

small font so my list will; fit on one paper and I can fold it, so it fits in my shirt pocket.

Anyway, I believe I found a workaround.

I've been setting the BackColor of the control to blue and white text.

I changed that to White BackColor and black ForeColor. It worked.

Excuse me if my explanation is a bit cloudy, I have trouble typing my thoughts.

Answer 5

Is this the same text month after month? I assume that's the case because you say, "A record I use frequently..."

Do you have the property, "Append Only" set to "Yes" or to "No" for this field?