Text box in a report not displaying more than 255 characters...

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rimvis

And also this:
http://www.woodyswatch.com/access/archtemplate.asp?5-12

Q:
Tara Santmire wants to know how to print Memo fields with more than 255 characters on an Access report, without truncation.

A:

All you need to do is set the CanGrow property of the text box bound to the Memo field to Yes.
Make sure that there are no other controls on the same line (that can interfere with the CanGrow property), and the text box will expand as needed to display all the Memo text.

rockiroads

Access seems to put a new line after so many characters (about 330 in mine), you can still see characters before but you got to scroll

Have you thought of using a richtext box control?

Rimvis

>> Hmm still working on oldlook Rimvis

Nope, found it on Google

Good point the CanGrow :-)

Nic;o)

sanjeevgogi

if your Report is getting its values from a query with 'totals' selected, then you only get 255 characters even if this field in your table is a memo.

jaffer

ASKER

I tried all that , but none of it seems to work. will I have to recreate the report?

Is your Report is getting its values from a query?

ASKER

jjafferr,
yes it is

Then I would probably use a subreport based on the table linked by the unique ID and just containing the memofield and (hidden) the unique key.
Every handling of a memofield in a query will indeed truncate the field :-(

Nic;o)

ASKER

Nico,

Can u expand on that ?

ASKER

another piece that I forgot to mention.. when I run the query independant of the report, all the text shows up .... this points to the direction that the text field in the report is truncating the textt... right?

sanjeevgogi

If you have a unique ID that you get from the query, then
1- Don't read this memo field from the query,
2- in the control source of the memo field in the report, use the dlookup function to get the memo info.

Jaffer

Hmm DLOOKUP will work probably, but will be slow.

Just create a subreport and refer to the original table with the memofield.
Access will propose a key to link with and when listed select the correct field(s).
Place the memofield and the unique id.

Clear ?

Nic;o)

Nico
Could you please elaborate on How slow is slow when talking about DLOOKUP?
I heared this before, but no body quantified it.

thanks

Just run a query on 100,000 rows with a JOIN and another without DLOOKUP, you'll be amazed.....

Nic;o)

ASKER

Nico,
that worked, but the table with the memo field has a one to many relationship with the main table. ie one value in the main table has multiple values in the table with the memo field. I tried using distinct in the record source query in the sub report, but I get an error saying :"The field is too small to accept the amout of data you attempted to add try inserting or pasting less data".

what is wrong? and how can I display only distinct values?

thanks a ton for your help....

Which one is needed?
When all are the same use TOP 1 instead of the DISTINCT.

Nic;o)

Nico;
Thanks, I got the picture

sanjeevgogi
why don't you try the DLOOK, it shouldn't take that much an effort of you, you might find it fast enough for your data.

Jaffer

ASKER

TOP 1? what is that?

Nico
if you have some time, please visit
https://www.experts-exchange.com/questions/20899224/Searching-multiple-Tables-in-one-database.html#10463071
as you might be able to help there too.

thanks

TOP 1 will select the first row from the found record(s).
Using a sortby you can influence the top one when needed.

Nic;o)

ASKER

nico,
I need all the dictinct rows
why doesnt distinct work? is there any other alternative?
thanks,
sanjeev

Then a subreport should be used with the memofield in the detail section.

Nic;o)

ASKER

nico ,
It is in the detail section
thanks,
sanjeev

Strange, it should repeat. Are your linkage fields filled correctly ?

Nic;o)