Semi-standard letters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use forms to produce a letter containing some standard info and the
client's name and address in a box for a envelope window. The user just
enters a specific message in a text box (control is a memo field). It works
fine for one page but they need can't write more than will fit in the text
box.

Is there a way to get the standard stuff sender & recipient name from the
table and let them write as much as they like?

I got a feeling I am missing something obvious but would appreciate some help.

pete
 
For additional infomration, why did you use a memo field instead of a text
field with the same field size?
 
memo fiels necessary as text field max characters is (about) 256 - nowhere
near enough - my users want to write long letters and keep the specific info
in the database???

pete
 
I use forms to produce a letter containing some standard info and the
client's name and address in a box for a envelope window. The user just
enters a specific message in a text box (control is a memo field). It works
fine for one page but they need can't write more than will fit in the text
box.

Is there a way to get the standard stuff sender & recipient name from the
table and let them write as much as they like?

I got a feeling I am missing something obvious but would appreciate some help.

pete
Click to expand...

I don't see any problem.
On the report, did you set the both the Control's CanGrow property
(that contains all the text), as well as the Detail Section's CanGrow
property to Yes.
 
I use forms to produce a letter containing some standard info and the
client's name and address in a box for a envelope window. The user just
enters a specific message in a text box (control is a memo field). It works
fine for one page but they need can't write more than will fit in the text
box.

Is there a way to get the standard stuff sender & recipient name from the
table and let them write as much as they like?

I got a feeling I am missing something obvious but would appreciate some help.

pete
Click to expand...

If you JUST want to let the user type in text, include it in the report, but
not save it in a table for later use... you can put a textbox on the report
with a control source

=Forms!YourFormName!YourTextboxName

Your form can have scrollbars in the textbox to allow basically unlimited
text; your Report textbox should have CanGrow and CanShrink set to Yes to
allow the textbox to expand to fit the text.

John W. Vinson [MVP]
 
Back
Top