Hello,

I pull data from an ODBC database (Lotus Notes) to a local acces database.

Some Fields in LN have multiple lines.
When i run my query the problem is that not all the data in some fields is red.
The LN database has a limit from 254 characters for this field but the query reads out only the +- 50 first characters.

Ho can i tell the query to read out all the characters ?

I put it in a local table with 254 characters.

Kind regards

Is the Access field, in design view, a Text, 50 character field? Probably.

Is the Access field, in design view, a Text, 50 character field? Probably.

I would add that if it is, changing it to a Memo Field might solve your problem.

Thanks for the answers.

I cannot change the property of the Lotus notes database field.

Changing the property to memo on the acces database do not solve the problem because the query reads out only +- 50 characters.

How can i put the notes field into the acces field without losing data.
I need the query because i am reading from diff tables in notes to a single table in acces.

thanks