Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    11

    Unanswered: Change font properties of a field value using CODE

    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!!!

  2. #2
    Join Date
    Feb 2004
    Location
    Gold Coast, Queensland, Australia
    Posts
    15

    Very close

    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
    YuriK

  3. #3
    Join Date
    Aug 2003
    Location
    Bologna - Italy
    Posts
    209
    Quote Originally Posted by Yuri Korin
    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.
    The only failure is not trying to do it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •