Re: Line spacing in text box

You can increase line spacing in text boxes in recent versions of Access - I
*think* Access 2002 was the first version to have this feature, though I'm
not 100% certain of that. Open a form in design view, select a text box, and
look for a Line Spacing property on the Format tab of the Properties window.

To force a line break, use vbCrLf in code, or Chr$(13) & Chr$(10) in SQL or
expressions. Examples follow ...

In code:
strSomeTextOnTwoLines = "This is the first line" & vbCrLf & "this is the
second line"

An expression:
="This is the first line" & Chr$(13) & Chr$(10) & "this is the second line"

--
Brendan Reynolds (MVP)

"Ian Chappel" <newsATian-chappel.com> wrote in message
news:%23gvlqQ8tFHA.3932@xxxxxxxxxxxxxxxxxxxxxxx
> Can I increase the line spacing of wrapped text in a text box?
>
> I am trying to print UK banking cheques, and need the amount-in-words to
> be over two lines. If I used a fixed width font I suppose I could split
> the string, but I am wondering if there's a simpler or more elegant way?
>


.

Relevant Pages

  • Are f.p. manipulation functions only used in initialization?
    ... I was writing some code with gfortran and found that spacing only ... worked in initialization expressions. ... RRSPACING, SCALE, SET_EXPONENT, and, SPACING were broken like this, ...
    (comp.lang.fortran)
  • Re: Help! Nested IF
    ... Your problem is that the spacing between the various expressions isn't ... > Only the first two conditions CPI Rent and %GRP without 5yrs work the ...
    (microsoft.public.word.docmanagement)
  • Re: Line spacing in text box
    ... > You can increase line spacing in text boxes in recent versions of Access - ... and look for a Line Spacing property on the Format tab of the ... > or expressions. ...
    (microsoft.public.access.forms)
  • Re: Make it fit
    ... pages worth of text) and have the VBA macro reduce the Font, Spacing, ... Margins so that it will fit into one page ... reduce it by one page by reduce the Font, Spacing, Margins etc. ... >No idea what the Word feature is that you've read about. ...
    (microsoft.public.word.vba.general)
  • RE: Font enlargment changes spacing
    ... If you enlarge the font size, the text is going to take up more space. ... Format, Paragraph..., Indents and Spacing, Spacing. ... using the document protection feature will allow for that, ...
    (microsoft.public.word.docmanagement)