471,887 Members | 1,812 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

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?
Nov 12 '05 #1
4 22391
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" <kr***@hotmail.com> wrote in message
news:41**************************@posting.google.c om...
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?

Nov 12 '05 #2
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" <Al*********@SeeSig.Invalid> wrote in message news:<40**********************@freenews.iinet.net. au>...
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.

Nov 12 '05 #3
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" <kr***@hotmail.com> wrote in message
news:41**************************@posting.google.c om...
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" <Al*********@SeeSig.Invalid> wrote in message

news:<40**********************@freenews.iinet.net. au>...
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.

Nov 12 '05 #4
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" <Al*********@SeeSig.Invalid> wrote in message news:<40**********************@freenews.iinet.net. au>...
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" <kr***@hotmail.com> wrote in message
news:41**************************@posting.google.c om...
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" <Al*********@SeeSig.Invalid> wrote in message

news:<40**********************@freenews.iinet.net. au>...
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.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by jimmyshaw83 | last post: by
2 posts views Thread by jacoballen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.