You have to set the CanGrow property to YES for the Control (textbox) and the SECTION it's in (Detail, for example).

Thanks Richard for the comment! But, actually the reason all the info is not showing is: uniqueness.

Here is the link where I found the answer: http://allenbrowne.com/ser-63.html. The suggested workaround is: You may need to create another query that selects the distinct values without the memo, and then use it as the source for another query that retrieves the memo without de-duplicating.

The reason I'm using unique value is because the query uses a many to many relationship (three tables). I need the info of the two tables that are not the joint table, but the joint table is causing the info i need to repeat. If it is not too much to ask Richard, can you make a video example for the workaround please?

I would love to, but I still have no idea what you're talking about. Sorry. Can you break it down for me in simpler terms. I can't visualize what you've got going on and what you're trying to do. If you can, email me screen shots of your database because it's sometimes easier if I can see what you've got going on. Sorry you can't post images here yet. I'm working on that.

So I solved this issue. First I separated the query in two queries: one for the unique values and the other for the not unique values. Then I created two reports one for each query and then connected the two reports by using one as the subreport. Sometimes for workaround you need a bit of imagination. Hope this help others with the same issue!

Interesting solution. Thanks for sharing.