Line spacing in text box

  • Thread starter Thread starter Ian Chappel
  • Start date Start date
I

Ian Chappel

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?
 
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"
 
Thanks Brendan,

Yes, it is there in my version (2002). I could have sworn I looked for it
before!
 
Back
Top