Replace vbCrLf

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

We have an asp.net page that displays data from a SQL table that is updated
from a VB application. That application uses vbCrLf to denote line breaks.
How can I replace them with "<br />" before they get displayed in my
GridView? Thanks.

David


.

Relevant Pages

  • Re: Neue Zeile in Memofeld schreiben mit Zeilensprung
    ... Die Jet Engine kann kein VBA. ... Die sucht nun in ihrem Repertoir verzweifelt nach einem Feld namens [vbCrLf] und meldet schlussendlich wohl, dass ein Parameter fehle, was ja auch richtig ist. ... Daher kannst Du statt vbCrLf als Behelf die Funktion Chr() mit dem Asci Code aufrufen. ... Sonderzeichen in den SQL String reingemogelt. ...
    (microsoft.public.de.access)
  • Re: Another SQL quandry
    ... & vbCrLf & _ ... "FROM tblMessLog INNER JOIN tblRecipients ON tblMessLog.RecipID = ... Copy SQL statement from query to VBA ... Dim strSQL As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: Query Nightmare!!!
    ... I'm not sure vbCrLf will work in SQL; it is a VBA constant as it begins with ... and ## to delineate string and date data in a SQL string. ... for some reason, the vbCrLf does not create a carriage return, although no ...
    (microsoft.public.access.queries)
  • Re: SQL
    ... 'FirstName' and 'tblContact', and so on. ... > INNER JOIN tblClient ... tblContact.Phone" & vbCrLf ... >> your SQL, ...
    (microsoft.public.vb.general.discussion)
  • Re: More than 1 filed in Select *
    ... If you want all columns from a table, and other values returned as well, you need to explicitly denote which table "*" refers to. ... SQL> select 0,dual.* from dual; ...
    (comp.databases.oracle.server)