Semi-standard letters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pete Rothery - 09 Nov 2007 19:43 GMT

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

Reply to this Message

Kinlye - 09 Nov 2007 20:08 GMT

For additional infomration, why did you use a memo field instead of a text
field with the same field size?

> 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
[quoted text clipped - 8 lines]
>
> pete

Reply to this Message

Pete Rothery - 09 Nov 2007 20:15 GMT

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

> For additional infomration, why did you use a memo field instead of a text
> field with the same field size?
[quoted text clipped - 11 lines]
> >
> > pete

Reply to this Message

fredg - 09 Nov 2007 21:12 GMT

> 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
[quoted text clipped - 8 lines]
>
> pete

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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

John W. Vinson - 10 Nov 2007 00:55 GMT

>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
[quoted text clipped - 8 lines]
>
>pete

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]

Reply to this Message