Hi,
i want to write a paradox script that goes through a table and checks some invalid values and outputs them to another table. The new invalid table should have these values displayed in RED so that when i use the paradox exportspreadsheet function, the invalids appear in RED.

I have figured out everything except for changing the font properties. Is there any function or property using which i can use to do this?

What i have done is as follows

scan table
if invalid record, output to invalid table
end scan

export invalid table as spreadsheet.


Now i was wondering if in paradox there is any such thing as
tcursor.record.field.fontcolor = "RED"

Please help!!!

The code that you had was very close to correct. What you need is:
tcursor.record.field.font.color = RED
RED is a Paradox constant of type LongInt.
This will change the font color, not the field color which is what I assume that you want. If you want to set the field's color, you will need this:
tcursor.record.field.color = RED
Once again, very close.
I hope this helps you.
Cheers,
Yuri

That's simply FALSE, as i've already told varun_b by private messages.

The tcursor is a DATA object, and as such HAS NO VISUALIZATION PROPERTIES.

You cannot show onscreen a tcursor: you must use a table frame, a form , or something like this to show the table; then, the tableframe field objects, within the record object will have the properties Yuri describes and so you'll be able to insert a script on the record's arrive event to turn red the field font color if a condition is verified.

To be perfecly clear: a tcursor has NO visualization properties at all, so that's simply not possible.