keep the spaces before the description line

[eddie wang]

How to keep the spaces before the description line in the following
code? Right now, it displays like "Net Income", but I like to have
spaces before the words like " Net Income". The database value is "
Net Income". Thanks!


<td align="right"><Font class=content4><%=ars.Fields("LINES")%></td>

 

[Aaron Bertrand [MVP]]

As I mentioned earlier today.

<td align="right"><Font class=content4><%=ars.Fields("LINES")%></td>

<td align="right"><%=replace(ars.Fields("LINES"), " ", "&nbsp;")%></td>

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

 

[eddie wang]

I use the replace function like the following and it doesn't work.

<td align="left" bgcolor="#FFFF99"><Font
class=content4><%=replace(ars.Fields("line_item_nm"),
"","")%></font></td>

 

[Aaron Bertrand - MVP]

I use the replace function like the following and it doesn't work.

<td align="left" bgcolor="#FFFF99"><Font
class=content4><%=replace(ars.Fields("line_item_nm"),
"","")%></font></td>

Who said to use it like that? You're replacing nothing with nothing. Of
course, it "doesn't work."

 

[Bob Lehmann]

Maybe you should try the example you were given....
<%=replace(ars.Fields("LINES"), " ", "&nbsp;")%>

Instead of what you wrote....
<%=replace(ars.Fields("line_item_nm"),"","")%>

Bob Lehmann

 

[eddie wang]

I found out that the following works. Thanks.

replace(ars.fields("lines"), " ", "&nbsp;")

 

[Bob Lehmann]

hmmmm.....
Imagine that.

Bob Lehmann