Report must be 1 page - can I dynamically change font prior to printing?

[Larry Kahm]

I have a unique client requirement: a specific report must be only 1 page
long.

There are several memo fields that comprise the detail section. 90% of the
data can successfully fit on one page; however, I am concerned with the
remainder.

Is it possible to:

a) determine if the data will not fit the page?
b) change the size of the font in a memo field prior to printing?

Thanks, in advance, for any help.

Larry

 

[Duane Hookom]

I believe Stephen Lebans has a solution at his site www.lebans.com. It seems
that site might be down at the moment.

 

[Larry Kahm]

The site seems to be up and running.

Now, to go figure out which of the report utilities I really need.

Thanks!

Larry

 

[Duane Hookom]

I was thinking this one http://www.lebans.com/autosizefont.htm but I could
be wrong...

 

[Larry Kahm]

Duane, that one's for use in forms (display-side). I've got it narrowed
down to http://www.lebans.com/PrintLines.htm.

I'm just going to have to spend some time thrashing through the code to see
where the Memo fields get modified.

Larry