ActiveX Control associated with TASK_RTF_NOTES column

[jr1664]

MSP 2003 Standard SP2
MS Access 2003 SP3

MPP has been exported to MDB.
I created an MS Access Form (what I really want is a Report, but start with
a form) based on the MSP_TASKS table with a MS RichTextbox Control version
6.0 with the Control Source being TASK_RTF_NOTES.
When I display the form, I get a string of mostly question marks with an
occasional percent sign. I was hoping to actually see the notes. I am
assuming that I need a different Active X contol since the display in
inaccurate.

 

[JulieS]

Hi jr1664,

Read the topic "Reading and writing RTF Notes" in the PJDB.HTM file
on your computer. It gives some VB code to execute to convert the
data into text.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[jr1664]

Julie,

Your suggestion was a large step forward, this converted the MS Access Query
output from question marks to text, albeit with all of the Rich Text
Formating information. This left me still short of my goal.

The next step came from a solution proposed by David McCarter at this web
address http://dotnettips.com/2007/09/20/ConvertRTFToText.aspx.

I activated the Microsoft Rich Textbox Control 6.0 (SP4). The menu path to
check if it is activated is Tools -> References and then make sure the
checkbox is checked. The location was C:\WINDOWS\system32\RICHX32.OCX on my
machine.

I stumbled around and developed the function below within my MS Access
database using the pattern that Mr. McCarter provided.
============
Public Function ConvertRtfToText(ByVal InString As String) As String

Dim Converter As New RichTextBox

Converter.TextRTF = InString

ConvertRtfToText = Converter.Text

End Function
============
The final step was to put these together in my query which then looks like:
Notes: ConvertRtfToText(StrConv([TASK_RTF_NOTES],64))

And voila, you have text from the notes field.

Thanks,
Jim

 

[JulieS]

Jim,

Thanks so much for posting the details of your resolution. I'm sure
it will help others in the future!

Julie

Julie,

Your suggestion was a large step forward, this converted the MS
Access Query
output from question marks to text, albeit with all of the Rich
Text
Formating information. This left me still short of my goal.

The next step came from a solution proposed by David McCarter at
this web
address http://dotnettips.com/2007/09/20/ConvertRTFToText.aspx.

I activated the Microsoft Rich Textbox Control 6.0 (SP4). The
menu path to
check if it is activated is Tools -> References and then make sure
the
checkbox is checked. The location was
C:\WINDOWS\system32\RICHX32.OCX on my
machine.

I stumbled around and developed the function below within my MS
Access
database using the pattern that Mr. McCarter provided.
============
Public Function ConvertRtfToText(ByVal InString As String) As
String

Dim Converter As New RichTextBox

Converter.TextRTF = InString

ConvertRtfToText = Converter.Text

End Function
============
The final step was to put these together in my query which then
looks like:
Notes: ConvertRtfToText(StrConv([TASK_RTF_NOTES],64))

And voila, you have text from the notes field.

Thanks,
Jim

Hi jr1664,

Read the topic "Reading and writing RTF Notes" in the PJDB.HTM
file
on your computer. It gives some VB code to execute to convert
the
data into text.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project