Memo fields truncated

  • Thread starter Thread starter roberto
  • Start date Start date
R

roberto

I have more memo field to view in my report.

But every memo is truncated to the 255th char.?

Why? and Waht I can do to resolve this?

Roberto Falchero
Solution Point Sas
Torino Italy
 
I have more memo field to view in my report.

But every memo is truncated to the 255th char.?

Why? and Waht I can do to resolve this?
Click to expand...

The usual reason for this is that the report's query is
doing something that requires Access to truncate the memo
field. Typical causes are using the memo field in a GROUP
BY or ORDER BY clause. If the problem is the ORDER BY
clause, get rid of it (reports use the Sorting and Grouping
window settings and ignore the sorting done in the query).
It's quite a bit messier to deal with a necessary GROUP BY
clause and I'd rather not go into it unless you really need
it.

Another cause is your use of a format in the memo's text box
in the report. Make sure the text box's Format property has
nothing in it.
 
Thank's for the answer but...

This my query:

SELECT confina.IDConfina, confina.Tipo, confina.N,
confina.Data, confina.RedattoDa, confina.PeriziaApprTipo,
confina.PeriziaApprN, confina.PeriziaApprData,
confina.PeriziaApprCapitolo, confina.PeriziaApprEsercizio,
confina.PeriziaIvaPerc, confina.SS, confina.Tronchi,
confina.Provincia, confina.Valuta, confina.Lavori,
confina.DocSospLavori, confina.DocConcProroghe,
confina.DocVerbCarotaggi, confina.DocDisegni,
confina.DocFotografica, confina.DocLibrettoGiornaliero,
confina.DocListaSettimanale, confina.LavoriPerizia,
confina.ImpegnoImp, confina.FinTipo, confina.FinN,
confina.FinData, confina.SuVerbData, confina.SuN,
confina.SuData, confina.LavoriImpMis,
confina.LavoriImpCpo, confina.LavoriImpEspr,
confina.LavoriDescr01, confina.LavoriImp01,
confina.LavoriDescr02, confina.LavoriImp02,
confina.LavoriDescr03, confina.LavoriImp03,
confina.LavoriDescr04, confina.LavoriImp04,
confina.LavoriDescr05, confina.LavoriImp05,
confina.SicurezzaImp, confina.AggLavoriTipo,
confina.AggLavoriN, confina.AggLavoriData,
confina.ImpresaAggNome, confina.ImpresaAggTipo,
confina.ImpresaAggIndir, confina.ImpresaAggCap,
confina.ImpresaAggCitta, confina.ImpresaAggProv,
confina.RibassoOff, confina.RibassoImp,
confina.CauzioneNome, confina.CauzioneN,
confina.CauzioneData, confina.CauzioneImp,
confina.AttoCottimoN, confina.AttoCottimoData,
confina.TempoUtileArt, confina.TempoUtileGG,
confina.PenaleRitArt, confina.PenaleRitImp,
confina.ConsLavData, confina.ConsLavVerbData,
confina.UltimLavData, confina.UtlimLavVerbData,
confina.UltimLavCertData, confina.Sospensioni,
confina.Proroghe, confina.AndamLav, confina.VariazApport,
confina.DanniForzaM, confina.DirezLavTipo01,
confina.DirezLavNome01, confina.DirezLavNomeSost01,
confina.DirezLavCausaSost01, confina.DirezLavTipo02,
confina.DirezLavNome02, confina.DirezLavNomeSost02,
confina.DirezLavCausaSost02, confina.DirezLavTipo03,
confina.DirezLavNome03, confina.DirezLavNomeSost03,
confina.DirezLavCausaSost03, confina.DirezLavTipo04,
confina.DirezLavNome04, confina.DirezLavNomeSost04,
confina.DirezLavCausaSost04, confina.DirezLavTipo05,
confina.DirezLavNome05, confina.DirezLavNomeSost05,
confina.DirezLavCausaSost05, confina.DirezLavTipo06,
confina.DirezLavNome06, confina.DirezLavNomeSost06,
confina.DirezLavCausaSost06, confina.NuoviPrezzi,
confina.ProveSaggi, confina.DocCertifProveDescr,
confina.ImportoLordo, confina.CertifAccQta,
confina.CertifAccImp, confina.RiserveQta,
confina.RiserveImporto, confina.Infortuni,
confina.Espropri, confina.AvvOpp, confina.Cessioni,
confina.AssicEnti, confina.AssicNPoliz,
confina.AssComEntiN, confina.AssComEntiData,
confina.AssComEntiElenco, confina.AssComEntiRisp
FROM confina
WHERE (((Year([Confina].[AttoCottimoData]))=
[Contratto_Anno]));

**** It is very long I know :-/ *****

The field confina.LavoriPerizia is one of Memo fields that
is truncate; all the Memo fields are truncate!
I don't use ORDER or GROUP BY.

I don't understand when you write about: memo field format
in report?
It's a standard field, generated by ms access, the
property CanGrow is true...

I have to change something else?
Can I send you my db?

Thanx in adv
Roberto Falchero
 
(e-mail address removed) wrote:

[snip the routine query]
The field confina.LavoriPerizia is one of Memo fields that
is truncate; all the Memo fields are truncate!
I don't use ORDER or GROUP BY.
Click to expand...

That's a very ordinary query. If you open the query from
the query design window, it should display all the data in
the memo fields. Does it?

I don't understand when you write about: memo field format
in report?
It's a standard field, generated by ms access, the
property CanGrow is true...
Click to expand...

Click on a memo field's text box in the report and display
its property sheet (View menu). Look through the property
sheet and make sure there is nothing in the Format property.
--
Marsh
MVP [MS Access]


 
Back
Top