VB.NET - bullet issue

Asked By thara on 28-Mar-11 09:30 AM

Earn up to 10 extra points for answering this tough question.

In Crystal Reports 8 I'm trying to preface each line in a text field with a
bullet. The text field has many lines separated with enter key.

I need the start of each new line to have a bullet (or bullet like
character).and it should appear in crystal report also.

Can anyone help?

Mike Manny replied to thara on 28-Mar-11 11:18 AM

From http://www.vbmonster.com/Uwe/Forum.aspx/vb-crystal/1295/inserting-bullet-at-start-of-newline

Dim Line as String
Dim LineArray() as String
LineArray = Split({rrr_PGP;1.HowMeasured}, CHR(10))
Line = Join(LineArray,"")
Line = Replace(Line,CHR(13),"*")
Line = Replace(Line, "**",CHR(13)+CHR(13)+chr(149))
Line = CHR(149)+Line
formula = Line

If that doesn't help, read the above post
I found this, you could try it

http://www.vbforums.com/archive/index.php/t-462232.html

Add a Text Object, set its Font to Marlett and set its text to the letter h or i.

Place the Text Object beside the Field/Formula Object and you should have a bulletted list.

Tom Wilson replied to thara on 28-Mar-11 11:42 AM

Using the RichTextBox you can add the bullets by setting the RichTextBox's SelectionBullet Property to true. Select the text in the RichTextBox, and set the SelectionBullet property to true in a button click event;

Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click

RichTextBox1.SelectionBullet = True

End Sub

or without selecting text,

Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click

RichTextBox1.SelectAll
RichTextBox1.SelectionBullet = True

End Sub

Save the richtextbox's RTF property to the database.

Crystal Reports does not interpret the RTF bullet identifier "pntext" correctly. So the bullets will not appear in Crystal reports. This is one workaround. Add a formula field to the Crystal Report. Use this formula (basic syntax):

formula = Replace ({?yourdatabasefield}, "pntext", "listtext" )

Add the formula field to the report and set the Text Interpretation to RTF text on the Paragraphs Tab of the Format Object screen.

thara replied to Tom Wilson on 29-Mar-11 04:07 AM

But how can we make the size of the bullet same. The size of first bullet is little bigger than others