Search results for query: *

The secret is to place the field directly in the report, not from a query. The SQL processes the memo field as a text field, truncating it to 255 characters. If you just plonk the memo field as an object on the report, it does not truncate. Mick Snowden Systems Support Engineer

Thanks, I'll try that. There are another couple of criteria that may affect it. The database the connection tables link to is part of a helpdesk system, that lives on a server at our other site. We only have a 64k link, which is shared by all 50 users at our site for data xfer between sites AND...

The following code should generate a recordset, and (to test that the data is actually being picked up) returns the value from the LogNo field in a Message Box. Set cnConnection = CurrentProject.Connection Set rsCallsClosed = New ADODB.Recordset rsCallsClosed.Open ("SELECT * FROM...

Thanks, John. I've checked the report, and the memo fields in question appear in the Detail section. Any more for any more? Mick Snowden Systems Support Engineer

Thanks, I've checked formatting in Table, Form and Report, and can see nothing other than Font and Font Size. Still no joy. This is so maddening and it appears to have no logical cause...... Any more ideas? Mick Snowden Systems Support Engineer

I too am having a problem getting a memo field to show correctly. Everywhere I look, the advice is to set the "Can Grow" property on both Form and Report. This I have done, but the memo field on the report is still only showing 255 characters maximum. The field at table level has no...