programmatically adding both normal and formatted text into the same cell

hi! i am using the Microsoft Office Spreadsheet 9.0 activex into a visual foxpro form. I want to add both bold and normal text into the same cell. How can this be done? Until now i managed to add only bold or only normal text in the same cell.... Is there a method to combine both types of formatting into the same cell?

Maybe some kind of chr(x) special characters? I have tried "<b>bold text</b>" but this didn't work.

So, hope someone has an idea . Thanks a lot!

stef

Hello Stef123,

I am not familiar Office Spreadsheet 9.0 ActiveX component for Visual FoxPro. I can tell you how it is done in Excel, and perhaps this will help you a little.

In Excel each cell as an Characters object class. This contains the Font class. You can then change single characters or groups of characters Font properties like color, bold, underline, etc.

Code Example:

Please Login or Register  to view this content.

This would bold the "T" in "My Text". This only works in Excel if the Excel version supports RichText. I don't know if this might apply to FoxPro as well.

Sincerely,
Leith Ross