html in vba

[7anthala]

i have a problem with this code it is multiline html paragraph
i attached the picture of the code and this is a sample

Private Sub Command124_Click()
If Me.Text120 = "Air contrasted colon examination for suspected invagination approach" Then
Me.REP_DETAIL = "<p>After placement of Foley catheter into the rectum; an amount of air been insufflated under flouro control. At the projection of the spleenic angle; there was an intra-luminal globular lobulated filling defect with air attenuation of arcuate branches patter at it lateral margins.</p>
<p>This finding is specific for intra-colonic invagination; repeated maneuvers for de-invagination were failed due to extended invaginated portion; surgical assessment is required</p>
<p> </p>
<p> </p>"


ElseIf Me.Text120 = "ASP X-Ray" Then
Me.REP_DETAIL = "<p><strong> </strong></p>
<p>On the obtained radiograph there was no evidence of free air presence under the diaphragm domes; the psoas margins are clear.</p>
<p>The stomach gases bubble common in location; the gases spreading in the colon is unremarkable.</p>"

 

[namliam]

To continue lines you use _
however you do need to end the string and concatinate it...
two options depending on your preference....

YourVariable = "text text "
YourVariable = YourVariable & "More more" 
YourVariable = YourVariable & "Even even" 
YourVariable = YourVariable & "more more"
etc...

Slightly faster in execution, though limitted to something like 25 lines I believe

YourVariable = "text text " & _
               "More more"  & _
               "Even even"  & _
               "more more" 
etc...

0

 

[7anthala]

it didnt work it gave me error : syntax error

 

[spikepl]

. .

 

[namliam]

What is giving you a syntax error?

 

[7anthala]

thanks namliam

YourVariable = "text text "
YourVariable = YourVariable & "More more"
YourVariable = YourVariable & "Even even"
YourVariable = YourVariable & "more more"

it worked very good