Maintine Access formatting in query results

I have an Access database with records containing a Memo field. The text in the field has formatting applied to it such as carriage returns and line breaks. Theses are not designated by characters like cr or lf. It is simply formatted as in this text box. When I output this field to the screen from a query result I lose all carriage return and line break formatting. How do I keep this formatting???
spiderbuzzAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
omgangConnect With a Mentor Commented:
Chr(13) is a carriage return character
Chr(10) is a line feed character
together they indicate a new line

Use this function to indicate these characters are actually in your memo field(s)

Also, the purpose of a query datasheet is to display the dynaset returned by the query.  The purpose of a form or report is to format that data for output to either screen or other medium.  You should use one of these to view your data correctly formatted.

OM Gang
Public Function FindNewLine()
On Error GoTo Err_FindNewLine
 
    Dim db As DAO.Database
    Dim rs As DAO.Recordset
    Dim strTableName As String, strMemoFieldName As String
    Dim varResult As Variant
    
    strTableName = "MyTable"
    strMemoFieldName = "MemoFieldName"
    
    Set db = CurrentDb
    Set rs = db.OpenRecordset(strTableName)
    
    rs.MoveFirst
    Do Until rs.EOF
        varResult = InStr(rs(strMemoFieldName), Chr(13) & Chr(10))
        Debug.Print varResult
        rs.MoveNext
    Loop
    
Exit_FindNewLine:
    Set rs = Nothing
    Set db = Nothing
    Exit Function
 
Err_FindNewLine:
    MsgBox Err.Number & ", " & Err.Description, , "Error"
    Resume Exit_FindNewLine
    
End Function

Open in new window

0
 
omgangCommented:
I guess I should have added the function will send it's results to the Immediate window so make sure to have it open.  Make sure to replace the values for strTableName and strMemoFieldName with those from your database.

OM Gang
0
 
spiderbuzzAuthor Commented:
Forgive me omgang,
So I would call this from within <cfoutput> tags and # 's?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
spiderbuzzAuthor Commented:
Actually I solved it using a ParagraphFormat() function on the output.

Thanks
0
 
omgangCommented:
<So I would call this from within <cfoutput> tags and # 's?>

No, you'd use it in the Access db to check for those special characters.

Glad you found a work-around.
OM Gang
0
 
spiderbuzzAuthor Commented:
I should have made it clear that I was looking for a ColdFusion solution. That which I am using is not a work around but a ColdFusion solution. I see no reason to run an additional procedure in the database when CF will maintain the formatting already present. Thanks for your answer
0
All Courses

From novice to tech pro — start learning today.