printing a memo field on a report

[etcrier]

I have a report that prints a query with a memo field that varies in length quite a bit from record to record.
For each record that prints i only want to allow space for the memo characters that exist for that record.
right now my notes in the memo field either get truncated or too much white space gets displayed.

any ideas.

thanks

david

 

[ZmrAbdulla]

Look for "Can Grow", "Can Shrink" in the properties (Format Tab) of the textbox.


________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[etcrier]

OK,

that works except for one small detail
if the memo field is too big for a page it still cuts off the text. is there a way to make it overflow the page to another page. there is no way to know how bug the membo field will be.
it varies from 1 line to many many lines.


thanks

david

 

[ZmrAbdulla]

I can't find that problem in my machine. In my test the memo field expands to many pages then next record.

See the link for limits

http://www.databasezone.com/techdocs/acclimit.html

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.