Showing full texts & avoid concatenation (1 Viewer)

[Jakmalan]

Hi All,
I have tried all the ways to get the full text without being truncated but in vain. Is there a way to make this applicable even to linke the table?
Appreciate your help,
I am still trying to attache the screen shot and the db

Regards,

 

[theDBguy]

Hi. Try zipping up the images before attaching them to your post.

 

[arnelgp]

is it a memo field?
use query, and put first the memo field in your query.

 

[MajP]

Do you mean truncated? In other words you are importing a memo field from Excel and it is truncating at 255 characters

 

[theDBguy]

Do you mean truncated? In other words you are importing a memo field from Excel and it is truncating at 255 characters

Ah, that makes sense.

 

[Jakmalan]

It is truncated. I have tried making it a memo field but still not working. I also tried to link the table and make the field memo but still always being truncated.
The wifi is very slow though the size is 1 mb.
i will try to upload it soon

 

[isladogs]

Allen Browne has a good summary of reasons why memo fields can be truncated.
http://allenbrowne.com/ser-63.html
You may be able to fix your issue after reading that.

 

[MajP]

If you mean truncated when linking or importing from a linked table, there are a couple of things that you can do.
When linking or importing into a table, Access looks at the first few rows (I heard about 9) and tries to determine the datatype. If is just sees short text fields in the first x rows then it assumes it is just short text. One trick is to add a bogus first row with more than 255 characters in the potential memo fields. This may or may not be viable. Or if you do this often you can automate in code writing the bogus row and then removing. The other way is to use the import wizard and import into a new table where you can define the datatype then insert from that table. You can save that import spec if a recurring activity.

I have tried a lot of other tricks in code to read it first and still failed. There is a lot on the internet about this.

 

[Jakmalan]

Thanks isladogs for the link. I have already gone through it before and other links too but still couldn't solve the puzzle.

@ theDBguy, the file is already zipped and it is 987 KB. Whenever I try to upload the file it turns back that the site cannot be reached though the speed is good now.
:banghead:
Is there a link that i can copy my DB to it or email it to someone?

 

[theDBguy]

Thanks isladogs for the link. I have already gone through it before and other links too but still couldn't solve the puzzle.

@ theDBguy, the file is already zipped and it is 987 KB. Whenever I try to upload the file it turns back that the site cannot be reached though the speed is good now.
:banghead:
Is there a link that i can copy my DB to it or email it to someone?

Hi. If you think email would work better, you can email it to me, and I can try to post it here for you.

 

[Jakmalan]

Hi theDBguy,
I have sent you the DB coz I found only your email. You can upload it if you like.
Thanks,

 

[theDBguy]

Hi theDBguy,
I have sent you the DB coz I found only your email. You can upload it if you like.
Thanks,

Hi. I'm still waiting. I don't see it in my inbox yet.

 

[theDBguy]

Hi. I'm still waiting. I don't see it in my inbox yet.

Hi. Just FYI, I never received your email, so you might want to give it another try. If I receive it later, I'll post it here.

 

[Jakmalan]

Finally here is the file

 

[isladogs]

Check Allen Browne's article again.
Remove the formatting (>) from the MatDescription memo field in the design of table tbl_PlantsAllItems. Try importing data to the table again

 

[Jakmalan]

Still doesn't show the full text.
The Excel file attached.

 

[arnelgp]

i imported the excel file as new table, no problem, not truncated.
i appended the imported file to new table, no problem also.
using a2016 x64.

 

[isladogs]

It works for me doing the following
1. Link the Excel file as a linked table Sheet1
2. Remove the > formatting from the table field then append the data using a query
3. I've compared the length of the linked field with the imported field using another query as a check.

I also tried importing direct from Excel to a new table. That also worked fine with no truncation. However I prefer using the first method as I have more control

 

[Jakmalan]

What I am trying to do is to have the full text which has more that 900 digits appear in the textbox (Material Descriptioin) from tblSAPLongDesc without being truncated.
I want to see the full text When I click on any item. You can see that there is a colum in the text box Search Result/s named (Count). It has the number of digits of the long text.

I have also attached the original tbl which has the full text.

 

[theDBguy]

What I am trying to do is to have the full text which has more that 900 digits appear in the textbox (Material Descriptioin) from tblSAPLongDesc without being truncated.
I want to see the full text When I click on any item. You can see that there is a colum in the text box Search Result/s named (Count). It has the number of digits of the long text.

I have also attached the original tbl which has the full text.

Hi. As the others were saying, this doesn't seem to be a problem for me either.