Output problem from variable

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

The output below is from a variable in a function.

What I need to do is to output it to a display with a line break at the <br>
part of the string.

Would be greatful for ant ideas please.

Les

Output format
Name:Sandra:Number:0777777777<br>Message 1 sent
successfully.<br>Name:David:Number:077555555555<br>Message 2 sent
successfully.<br>

Required result:

Name:Sandra:Number:0777777777<br>Message 1 sent successfully.<br>
Name:David:Number:077555555555<br>Message 2 sent successfully.<br>"
 
Les said:
The output below is from a variable in a function.

What I need to do is to output it to a display with a line break at the <br>
part of the string.

Output format
Name:Sandra:Number:0777777777<br>Message 1 sent
successfully.<br>Name:David:Number:077555555555<br>Message 2 sent
successfully.<br>

Required result:

Name:Sandra:Number:0777777777<br>Message 1 sent successfully.<br>
Name:David:Number:077555555555<br>Message 2 sent successfully.<br>"
Click to expand...


You can concatenate Chr(13) & Chr(10) into you output
strings where you want a new line.
 
Marshall thanks for that

Sorry I obviously did not make it clear what the problem is.

I need to know is how to display this info so the user can view it in a list
format as there could be several hundred in the format below and I can't
find a way to output this list to the user, say to IE display or like a
query result type output!

Can you suggest anything for this.

Les
 
Les said:
Sorry I obviously did not make it clear what the problem is.

I need to know is how to display this info so the user can view it in a list
format as there could be several hundred in the format below and I can't
find a way to output this list to the user, say to IE display or like a
query result type output!
Click to expand...


I think I'm still not clear on where the data is coming
from. Does this function return one huge string that you
want to display with the literal substring "<br>" replaced
by a new line? If so, then I think all you need to do is
assign the function's result to a text box on a form:

Me.textbox=Replace(yourfunction(),"<br>",Chr(13) & Chr(10))

If the result of the function is just one line, then you can
concatenate that to what's already in the text box

Me.textbox=Me.textbox & Chr(13) & Chr(10) yourfunction()



 
Back
Top