Too much text

[Sally]

I have a report with too much text for one label so I use two. It looks fine in Design view but when I preview it the label areas overlap or leave too wide a gap. Any ideas about how I can get round this one, please?

Thanks

 

[Rich]

Why can't you use one label and just make it bigger.

 

[Sally]

I can't put it all in one text box because there is too much text - it exceeds 255 characters

 

[David R]

You should be able to define it as a Memo field in a query (if it's a concatenation of other fields), then pull it into your report from there.

 

[boblarson]

You should be able to fit it in a text box as a text box will accept 65,535 characters and a label will accept 2,048 characters.

If you can't your table field data type may not be set as Memo.

BL

 

[Sally]

Sorry... I don't mean text box - I still mean label (as per the first message. Can I join the contents of two labels?

 

[boblarson]

Why not use a text box and format it like a label? It'll display more text than you should need and then it'll solve the problem without having to try to use two text boxes.

BL

 

[Sally]

I have tried using a textbox and

= "blah blah etc"

but I get to the stage where it says "text too long to be editted" and won't let me do any more.

Any more ideas please? Could I put it in a table as a memo and use Dlookup? If so, wouldn't there be a problem with running a query to produce the report (as I do)

Thank you

 

[boblarson]

Okay, now we're getting somewhere. The reason you can't fit that many characters in, is that you're using the RECORDSOURCE to input the text and it cannot accept more than 255 characters.

I'd say that you will probably have to add it as a memo field in a table and use it that way (using DLookup) by displaying it with a text box.

BL
hth

[This message has been edited by boblarson (edited 05-28-2002).]

 

[Sally]

Thanks very much, Bob. That's done the trick. Thanks especially for persevering with me on this!