Memo indent by record

[mogll]

Is it possible to indent specific records in a memo field based on the input
in related field in the record? If so, what coding is needed? Sample data:
txtSectionNo memSectionParagraph
1 Sample text for the section header
1.1 Sample text for the subsection
1.1.1 Sample text for the sub-subsection
2 Sample text for next section
2.1 Sample text for sect 2 subsection

In general, what I'm trying to do is simulate section bullets. Thank you.

 

[KARL DEWEY]

Try using an IIF statement in your form or report like this --
Expr1: IIF(Len([txtSectionNo])<2, [memSectionParagraph],
IIF(Len([txtSectionNo]) Between 3 And 4, "0000" & [memSectionParagraph],
"0000000" & [memSectionParagraph]))

 

[John W. Vinson]

Is it possible to indent specific records in a memo field based on the input
in related field in the record? If so, what coding is needed? Sample data:
txtSectionNo memSectionParagraph
1 Sample text for the section header
1.1 Sample text for the subsection
1.1.1 Sample text for the sub-subsection
2 Sample text for next section
2.1 Sample text for sect 2 subsection

In general, what I'm trying to do is simulate section bullets. Thank you.

An Access Memo field - by itself - doesn't have much at all in the way of data
formatting tools. It's not like Word or even Wordpad; it's just a repository
for a mass of text, and Access itself doesn't provide formatting tools.

You might want to construct your memo contents in a program which does have
such tools (this should be easy enough in Word, for example) and copy and
paste the text into the memo field. Sorry I don't have a better answer!

John W. Vinson [MVP]

 

[KARL DEWEY]

My post will only indent the first line of data.
To indent all of the data in your report try this --
Create three texboxes, set Can Grow property to Yes, drag height to minimum.
Use this for first textbox control source --
=IIF(Len([txtSectionNo])<2, [memSectionParagraph], Null)
For second --
=IIF(Len([txtSectionNo]) Between 3 And 4, [memSectionParagraph], Null)
For third --
=IIF(Len([txtSectionNo])>6, [memSectionParagraph], Null)
Stagger the textboxes for indentation.

--
KARL DEWEY
Build a little - Test a little

Try using an IIF statement in your form or report like this --
Expr1: IIF(Len([txtSectionNo])<2, [memSectionParagraph],
IIF(Len([txtSectionNo]) Between 3 And 4, "0000" & [memSectionParagraph],
"0000000" & [memSectionParagraph]))

--
KARL DEWEY
Build a little - Test a little

Is it possible to indent specific records in a memo field based on the input
in related field in the record? If so, what coding is needed? Sample data:
txtSectionNo memSectionParagraph
1 Sample text for the section header
1.1 Sample text for the subsection
1.1.1 Sample text for the sub-subsection
2 Sample text for next section
2.1 Sample text for sect 2 subsection

In general, what I'm trying to do is simulate section bullets. Thank you.