Prob on memo

[Krish]

Hi,

Thanks if any one can give hint how to combine multiple
lines in reports from a memo field (Data entered as
multiple lines by giving enter key from the form).

How do i give a line break if a coma or semicolon is found
int he text box or memo field.

Krish.

 

[Larry Linson]

I'm not sure, exactly, what you mean by "combine mutliple... from a memo
field". If you mean you'd like to eliminate the NewLine codes, they are the
ascii codes for Carriage Return followed by LineFeed, or Chr$(13) &
Chr$(10). There is also a builtin constant for use in VBA code, vbCrLf.
You'd write code to find and remove them from the text.

To create a line break, you'd write code to replace the character(s) you
mention with the two-character codes described above.

Larry Linson
Microsoft Access MVP