Display Tool Tip from Oracle

[KimMichael]

I am trying to set up a multi-line ToolTip using a Oracle table for the data source, I have done this before without any problem. However I now have a new table that contains a comma in the data.

Here is what my tip looks like
"NB CODE" ||'-' ||"NB NAME"||'\nSergeant '||OFFICER

The column name "OFFICER" contains data that is formatted like so"lastname, firstname" of course with out the double quote.

If I just use the column name OFFICER the ToolTip works and displays the names.

So my question is, is there a way to display this info on a multiline ToolTip?

Thanks

[LochDhu]

I have no problem with multiline tooltips from Oracle 9i R2.

'Key: '||KEY||'\nName: '||NAME

Some NAME values have comma's in them and they show up fine.

Scott