Paragraph indentation

[boybigote via AccessMonster.com]

Is it possible to indent the first line of every paragraph in a access report?

 

[Larry Linson]

Is it possible to indent the first line of every
paragraph in a access report?

Access itself doesn't work with "paragraphs", so it will be up to you.

Assuming your separation for a paragraph is the VBA built-in constant
vbCrLf, used either once if you want no space between paragraphs, or twice,
if you want a double-space between them, you can simply follow the "vbCrLf"
with a quoted string of the number of spaces you want to indent.

Me.txtMyTextBoxDisplay = " " &
"sometextstringwhichcouldbestoredinavariable" _
& vbCrLf & " " &
"nextparagraphwhichcouldbestoredinavariable"

If you want other formatting, too, then you might investigate using a
third-party "Rich Text" control. MVP Stephen Lebans has one at his website
http://www.lebans.com, which is free for the downloading. FMS, Inc. sells a
product for this purpose, http://www.fmsinc.com.

Larry Linson
Microsoft Access MVP

 

[Marshall Barton]

Is it possible to indent the first line of every paragraph in a access report?

Access reports do not have "paragraphs", so the answer is
no.

OTOH, if a "paragraph" is the content of a (can grow) text
box. you can "indent" the first line by addint some spaces
to the value:
=String(4, " ") & thefield

Or if you have a multi-paragraph memo field with a specific
string of characters that separates the paragraphs (e.g.
cr lf cr lf), you can add spaces in the middle of the text:

=String(4, " ") & Replace(thefield, Chr(13) & Chr(10) &
Chr(13) & Chr(10), Chr(13) & Chr(10) & Chr(13) & Chr(10) &
String(4, " "))

Beyond that kind of thing, I don't think there is much you
can do about it.