MEMO Fields 1

[techie2]

Hi,

Using Access 2000

I have a Memo field in 1 table which has lots of data.

I have created query for creating one report and if I place this Memo filed in the query and then in the report, report never comes back.

To work around, I had to use PresSit: Left([Presenting Situation],1000)to display some data.

How to use Memo fields to display full data in the report and are there any limitations of using Memo fileds in the reports.

Any help ??

V

 

[dhookom]

Maybe you should tell us what you mean by "report never comes back". Are you using page numbering and or keeping groups together?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[techie2]

Report has 2 groups "Department" and "Patient Name".

In both the groups "Keep Together" is set to NO.

Report does not come back means, it is runnuning forever.

Any more thoughts ??

V

 

[dhookom]

I also asked if you were using page numbering. If you are, try to remove it and test.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[techie2]

Hi,

Thanks a lot, By removing the page number, report shows up.

I have one more problem, when I set Memo field to yes for "Auto Grow", I get so many blank pages but if I set it to "Not grow" and increase the size of field, it shows up that much data. Problem is, some data in Memo fileds go to around 3-4 pages and I need to set it to Auto grow.

Any thoughts ??

V

 

[dhookom]

I don't have a clue regarding where/what section your blank pages are coming from. Do you have page break controls in your report? Are you forcing page breaks anywhere?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[techie2]

OK,

It is fixed, "Keep Together" was the culprit.

I am giving you STAR for pointing me to right direction and thanks to TEK-TIPS, it's a great forum.

V