Text line spacing

[garywood84]

Is it possible to reduce the line spacing of text in reports generated by Access?

Thanks,

Gary

 

[Brianwarnock]

What is most likely causing too large a space is the layout in your design, ensure that the object boxes only just fit in the space between sections.

Brian

 

[garywood84]

Thanks for your reply, Brian. However, I meant spacing between lines of text in a text box, rather than between records. I have a text box which has text that flows over 4 lines. The gap between each of these lines is quite big and I want them closer together, so I can get more info on each page. I don't think it's possible, but if anyone can point me in the right direction, I'd appreciate it...

Gary

 

[statsman]

Are you using a number of text boxes in this area or only 1 set to memo?

If you are using a number of different text boxes, try creating a calculated field in your query to merge them (if there is no problem with them running together).

In the query, create a new field in the first blank space on the right. We'll call it Temp for now. Enter the following:
Temp: ([text1]&" "&[text2]&" "&[text3]) etc. for each text field you wish in this new field.
On the report insert the new field Temp and set the Property - Can Grow to yes.
This will truncate the data. The line spacing will be set to whatever font and size you set for the box.

 

[garywood84]

statsman,

Thanks for your reply. However, the text I want to alter the line spacing of is already in a single memo field.

In Word, for example, it's possible to change the line spacing between each line (to 1.5 or double, for example, but also to less than single). That is what I wanted to do on my report. I've given up and just used a smaller font, because I don't think it's possible.

It would be a useful feature if it could be added in future, I'm sure, though.

Gary

 

[boblarson]

Gary -

I'm guessing that you are using Access 2007, based on some of your other recent posts. I know that there is a LINE SPACING property for text boxes so you can set it to 0" if it isn't already. If it is, then I'm not sure how you would work it, but you can experiment - maybe it will take negative numbers.

 

[garywood84]

Bob,

Thanks for this. I'd missed the Line Spacing property, but have just experimented with it following your post. It does adjust the line spacing - I can increase the gap between lines by raising the value above 0. Unfortunately, though, the value can't be less than 0, so I can't make the lines closer together.

Just thinking about it, I wonder, if I were to use a monospaced font like Courier New, if I could work out how many characters fit across the width of the space I have, and then use some code to take that many characters from the start of my memo field and put them in a single line text box. I could then have a second text box to take the rest of the text, and position them closer together than the lines would be in a single text box...

It's late, and I'm tired, now, but perhaps I'll give that some more thought tomorrow - any ideas how I could get Access to take only the first X characters from the field and then only chracters from X+1 to the end of the second box?

Thanks,

Gary

PS: The other problem is that this may place the line-break in the middle of a word, so I'd need the code to find the space immediately preceding X characters... perhaps it's not a workable solution afterall?