Carriage Return or Line Feed

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I created a Memo field for a report. I wanted to "force"
a carriage return (line feed) at certain parts of the memo
field so that when outputed to a report the carriage
return and line feed will take into effect. To do this I
imbeded a Chr (10) "line feed" on the memo field. It did
not work. I then tried to use Chr (13) "carriage return"
no luck either. What displayed is a "square" in the
report (output).

Please help....

Thanks,
Fred
 
Fred,
You MUST use both
chr(13) & chr(10)
in that order.

If you are doing this using VBA then, in addition to the above, you can use
vbCrLf
or
vbNewLine

Why not place the carriage returns while you are entering the data in the
form?
Either set the Enter Key Behavior property to "New Line in field"
or enter the return by pressing Ctrl + Enter.
 
Back
Top