can format memo fields (line breaks, etc.) in Access reports?

I have a memo field that is included in some Access reports I created.
Is there some way for the memo field to display nicely formatted text,
with line breaks between paragraphs? Or is it necessary to export the
report?

I tried exporting a report by using the .rtf rich-text format (the
plain-text format was the only other word-processing option listed
when exporting). I then opened the .rtf file in Word. However, it
looks like some manual adjustments are necessary when adding line
breaks into a memo field (adjustment of the next tab over – to move it
further to the right – when making the field for the memo field a bit
wider, since the addition of line breaks and attempts to line up the
text can result in a wider block of text).

Is there a better, less manual way to make formatting of line breaks
occur in memo-field text?

re: can format memo fields (line breaks, etc.) in Access reports?

The memo field should handle line-breaks correctly where you have embedded
CR-LF pairs within the field (i.e. ascii 13 and ascii 10).

You may be able to use the Replace() function to replace actual embedded
characters with the format you want.

Alternatively, if you want to go with rich text, visit www.lebans.com for a
rich text control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"intl04" <kr005@hotmail.com> wrote in message
news:414cb645.0401281028.37b9ef57@posting.google.c om...[color=blue]
> I have a memo field that is included in some Access reports I created.
> Is there some way for the memo field to display nicely formatted text,
> with line breaks between paragraphs? Or is it necessary to export the
> report?
>
> I tried exporting a report by using the .rtf rich-text format (the
> plain-text format was the only other word-processing option listed
> when exporting). I then opened the .rtf file in Word. However, it
> looks like some manual adjustments are necessary when adding line
> breaks into a memo field (adjustment of the next tab over - to move it
> further to the right - when making the field for the memo field a bit
> wider, since the addition of line breaks and attempts to line up the
> text can result in a wider block of text).
>
> Is there a better, less manual way to make formatting of line breaks
> occur in memo-field text?[/color]

re: can format memo fields (line breaks, etc.) in Access reports?

Could you tell me how users accessing a data entry form connected to
the Access database can enter CR-LF pairs within the memo field? I did
a Google search on 'CR-LF' and found a lot of information - but it
mostly pertained to exporting and importing text between different
platforms and programs, from what I could see. Is it possible to put
in \r\n into the text, to insert paragraph breaks into the memo field
that will also appear in printed reports? Or what are the characters
to represent CR-LF, if not \r\n?



"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message news:<40187b89$0$1753$5a62ac22@freenews.iinet.net. au>...[color=blue]
> The memo field should handle line-breaks correctly where you have embedded
> CR-LF pairs within the field (i.e. ascii 13 and ascii 10).
>
> You may be able to use the Replace() function to replace actual embedded
> characters with the format you want.
>
> Alternatively, if you want to go with rich text, visit www.lebans.com for a
> rich text control.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>[/color]

re: can format memo fields (line breaks, etc.) in Access reports?

If you have a text box on a form where the users enter the info into the
memo field, set the text box's EnterKeyBehavior property to:
New line in field
When they press the Enter key, it inserts a carriage-return line-feed pair.

Alternatively, Ctrl+Enter inserts a cr-lf.

In code, use vbCrLf. For example, this line adds a new line to the existing
data in a memo field:
Me.MyMemo = Me.MyMemo & vbCrLf & "Some more stuff"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"intl04" <kr005@hotmail.com> wrote in message
news:414cb645.0401290706.4d0acde5@posting.google.c om...[color=blue]
> Could you tell me how users accessing a data entry form connected to
> the Access database can enter CR-LF pairs within the memo field? I did
> a Google search on 'CR-LF' and found a lot of information - but it
> mostly pertained to exporting and importing text between different
> platforms and programs, from what I could see. Is it possible to put
> in \r\n into the text, to insert paragraph breaks into the memo field
> that will also appear in printed reports? Or what are the characters
> to represent CR-LF, if not \r\n?
>
>
>
> "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message[/color]
news:<40187b89$0$1753$5a62ac22@freenews.iinet.net. au>...[color=blue][color=green]
> > The memo field should handle line-breaks correctly where you have[/color][/color]
embedded[color=blue][color=green]
> > CR-LF pairs within the field (i.e. ascii 13 and ascii 10).
> >
> > You may be able to use the Replace() function to replace actual embedded
> > characters with the format you want.
> >
> > Alternatively, if you want to go with rich text, visit www.lebans.com[/color][/color]
for a[color=blue][color=green]
> > rich text control.[/color][/color]

re: can format memo fields (line breaks, etc.) in Access reports?

Thanks for the helpful info! I decided not to modify the
EnterKeyBehavior property, though. I just found what I needed at
http://www.columbia.edu/kermit/ascii.html . It gives ctrl-key
combinations to produce ASCII characters: for example, entering ctrl-j
or ctrl-m twice will give a paragraph break (ctrl-j produces a line
feed and ctrl-m produces a carriage return). So, I'm just asking the
end users of the database to use those keys to produce paragraph
breaks.


"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message news:<401923d5$0$1725$5a62ac22@freenews.iinet.net. au>...[color=blue]
> If you have a text box on a form where the users enter the info into the
> memo field, set the text box's EnterKeyBehavior property to:
> New line in field
> When they press the Enter key, it inserts a carriage-return line-feed pair.
>
> Alternatively, Ctrl+Enter inserts a cr-lf.
>
> In code, use vbCrLf. For example, this line adds a new line to the existing
> data in a memo field:
> Me.MyMemo = Me.MyMemo & vbCrLf & "Some more stuff"
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "intl04" <kr005@hotmail.com> wrote in message
> news:414cb645.0401290706.4d0acde5@posting.google.c om...[color=green]
> > Could you tell me how users accessing a data entry form connected to
> > the Access database can enter CR-LF pairs within the memo field? I did
> > a Google search on 'CR-LF' and found a lot of information - but it
> > mostly pertained to exporting and importing text between different
> > platforms and programs, from what I could see. Is it possible to put
> > in \r\n into the text, to insert paragraph breaks into the memo field
> > that will also appear in printed reports? Or what are the characters
> > to represent CR-LF, if not \r\n?
> >
> >
> >
> > "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message[/color]
> news:<40187b89$0$1753$5a62ac22@freenews.iinet.net. au>...[color=green][color=darkred]
> > > The memo field should handle line-breaks correctly where you have[/color][/color]
> embedded[color=green][color=darkred]
> > > CR-LF pairs within the field (i.e. ascii 13 and ascii 10).
> > >
> > > You may be able to use the Replace() function to replace actual embedded
> > > characters with the format you want.
> > >
> > > Alternatively, if you want to go with rich text, visit www.lebans.com[/color][/color]
> for a[color=green][color=darkred]
> > > rich text control.[/color][/color][/color]