Skip to Content

Anyway to change font color in SQL Preview window

Hi

I am looking for ways to change the font color for comments created in SQL Preview window. I have customized the DDL generation options to produce some comments in the DDL generation code. But the comments show up in the SQL Preview window with a bright green color. Where I Can set the color for a comment generated in DDL preview window?

thank you

Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 14, 2016 at 07:25 PM

    You're not alone disliking the green.  This one has been answered a few times (I have to find it every time I get a new laptop 😊).  Here you go (adjust path for version 16)

    For change the text colors:

    - Open the registry

    - Open the node Software\Sybase\PowerDesigner 9\Controls\Editor

    - Open the node of the file type, for example, SQL Files

    - Open the Color Groups node

    - Select a category, for example, Comment

    - Create a new DWORD entry

    - Rename the entry to Foreground

    - Change the value of the entry to: BBGGRR in hexa format.

    Example: 0000FF (red), FF0000 (blue)

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 14, 2016 at 08:32 PM

    Thank you Rich. It worked like a charm. I thought for a minute that I may not have rights to change REGEDIT settings. but surprisingly I was able to and it works.

    Thank you Very Much.

    Krishna

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 17, 2016 at 08:32 AM

    Nice answer, Rich. It made me think, it must be possible to set this value using a user profile, and I was right 😊. You need to create a Numeric item, and provide the decimal code for the colour, otherwise the process is the same:

    This changes the comment colour to BlueViolet

    You can create the folder structure in the User Profile yourself, or create a new User Profile based on <<Registry>> (and take out most of the content).

    I've attached a simple user profile - apply this via Tools | Apply User Profile. You need to store the file in your user profiles folder, and change the file extension from 'txt' to 'upf'.

    If you prefer to use REGEDIT, look up the HEX codes here - http://html-color-codes.info/color-names

    The PD User Profiles use Decimal codes - convert HEX to decimal here - http://www.rapidtables.com/convert/color/hex-to-rgb.htm (can also preview colours from here).

    Add comment
    10|10000 characters needed characters exceeded