By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,850 Members | 967 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,850 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.