field size on form (text is not all visible)

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

(Access 2000)


I have a form and some of the records that it displays actually fill the
field to the point that the form doesn't display all the text in it.


I am trying to accomplish the following:

Allow this field on the form to expand (be bigger) so all the text is
visible on the form. But i don't want to resize the form so it prints on two
pages... unless it needs to too print the handful of larger records in this
field.

Hopefully I am explaining some what clearly?

TIA,
_Bigred
 
_Bigred said:
(Access 2000)


I have a form and some of the records that it displays actually fill
the field to the point that the form doesn't display all the text in
it.


I am trying to accomplish the following:

Allow this field on the form to expand (be bigger) so all the text is
visible on the form. But i don't want to resize the form so it prints
on two pages... unless it needs to too print the handful of larger
records in this field.

Hopefully I am explaining some what clearly?
Click to expand...

I'm not sure, but I think Stephen Lebans' solution at

http://www.lebans.com/textwidth-height.htm

works with forms as well as reports. If not, he has an older solution
at

http://www.lebans.com/autosize_textbox.htm

I should point out that forms aren't really all that good for printing;
a better solution is to design a report for the purpose. You can make
it look like the form, if you want.

That said, if it's the printing of the form you're concerned with, not
the screen appearance, have you tried setting the text box's CanGrow
property? I haven't done this on a form, as I always use reports to
print, so I don't know how well it works.
 
Back
Top