indenting and line spacing in Access

  • Thread starter Thread starter Christina
  • Start date Start date
C

Christina

We need to create a two column report where the right-hand
column is converted to indented outline format. The text
currently has the outline labels such as I. a) b) c) but
is not indented. Since the user needs the main outline
levels to line up with sections in the left-side column,
she needs to also enter several carriage returns in the
outline to space things correctly.

Any ideas of how to accomplish this formatting without
doing it manually?

Any ideas are appreciated,
Christina
 
Access is not word processing software. It appears that you are storing an
outline with every level as a record of the same type, not hierarchical or
relational data. That means there is no "native", "easy" way to do what you
ask.

It would be possible, if you have some skills with VBA code, to write code
in the Print event of the detail section of a report to determine from the
outline _numbering_ what level it is and to prepend an appropriate number of
spaces for that level.

If you will be very specific about the format of the outline numbering,
perhaps someone here can give you more detailed suggestions. But also be
aware that, without some specific option settings, Access and the included
VBA language do not distinguish between upper- and lower-case.

Larry Linson
Microsoft Access MVP
 
Back
Top