vbLf and vbCr not recognized in query view 1

[jrh1]

I have a query that calls a function to populate a column.

The function returns a string with embedded vbLf and vbCr (linefeeds and carriage returns).

The resulting string has the "square box" character that signifies a non-recognized character.

Question - can I use characters other than vbLf and vbCr in my code so that the system recognizes them?

Thanks in advance,
Jeff

 

[dhookom]

You can't use these constants in a query. You can however use Chr(13) & Chr(10). They must be in this order.

Duane
MS Access MVP