Search results

Thank you all for your time and support. Inspired by your ideas, i saw that the text is truncated in the query first. When i creat a form based on a tbl it doesnt truncate the text. Is it possible to reflect the full text in the qry result?

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...

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

Finally here is the file

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

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...

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. :D i will try to upload it soon

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,

Hi Thumber75, I had the same issue before. Try to change the (bound Column) to 1 under the (data) in the property Sheet. Hope this would help.

Minty, what else should be added. You guys have covered so many topics. I havent had time to go through all of them. Thank you all for what you do.

This is a great Forum.