Re: Line spacing in text box

Thanks Brendan,

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

"Brendan Reynolds" <brenreyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ukGLYMFuFHA.3256@xxxxxxxxxxxxxxxxxxxxxxx
> 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?
>>
>
>


.