Memo field truncating in form

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

Guest

I've created a form to create e-mail form letters (e-mail Form 1), which are
then selected via a combo box in e-mail Form 2 to send to individual
customers. The selection of an e-mail type brings in the subject line and the
body of the e-mail.

When I make the selection, only the first 255 characters are brought into
the text box in Form 2. It is based on a memo field and is set to Can Grow.
when I look at the query for the combo box, all the text from the original
e-mail is there.

I found a response from Allen Browne to a post about the same problem with a
report. From that post, here are the things I have checked:
1) the query does not include the Distinct keyword (Unique Values are set to
no in query properties)
2) there is nothing in the Format property of either of the two text boxes
(Form 1 and Form 2) or of the memo fields in the two underlying tables
3) the detail section of both forms is set to Can Grow

The body control on both forms will accept all the text. I can paste the
e-mail body into Form 2 and fire the Send Object code and everything appears
in the Outlook e-mail.

Is there anything else I can try?
 
Susan,

Can't help you on why exactly 255 characters are appearing in the control,
but you may have a mis-conception regarding "CanGrow". From VBA Help:

"This property affects the display of form sections and controls only when
the form is printed or previewed, not when the form is displayed in Form
view, Datasheet view, or Design view. "

So, setting CanGrow to True does not affect what you see when your form is
displayed on the screen. It would only allow the section and text box to
expand when you sent the form image to the printer.

It also does not affect the data. In form view, any additional characters
beyond what the control can display on the screen would simply not be visible
on the screen, but still should be present in the data. If there is a double
line feed at the last visible line, it could appear that nothing else
followed, when it was simply not visible.

Try:
1) Enlarging the control on the form to see if more text becomes visible.
2) Sending the form to the printer to see if all of the text appears when
printed.
3) [Long shot] Manually requerying that one control after the record is
initially loaded into the form.
4) [Another long shot] Adding a vertical scroll bar to the control (if not
already there).

Bruce
 
Thanks, Bruce. I now understand can shrink/grow. My apologies for posting
this twice. I had a crash -- and when I checked -- the first post did not
appear.

Someone suggested using DLookup function, so I'm "studying" that. Thanks
again.
--
susan


BruceS said:
Susan,

Can't help you on why exactly 255 characters are appearing in the control,
but you may have a mis-conception regarding "CanGrow". From VBA Help:

"This property affects the display of form sections and controls only when
the form is printed or previewed, not when the form is displayed in Form
view, Datasheet view, or Design view. "

So, setting CanGrow to True does not affect what you see when your form is
displayed on the screen. It would only allow the section and text box to
expand when you sent the form image to the printer.

It also does not affect the data. In form view, any additional characters
beyond what the control can display on the screen would simply not be visible
on the screen, but still should be present in the data. If there is a double
line feed at the last visible line, it could appear that nothing else
followed, when it was simply not visible.

Try:
1) Enlarging the control on the form to see if more text becomes visible.
2) Sending the form to the printer to see if all of the text appears when
printed.
3) [Long shot] Manually requerying that one control after the record is
initially loaded into the form.
4) [Another long shot] Adding a vertical scroll bar to the control (if not
already there).

Bruce


Susan L said:
I've created a form to create e-mail form letters (e-mail Form 1), which are
then selected via a combo box in e-mail Form 2 to send to individual
customers. The selection of an e-mail type brings in the subject line and the
body of the e-mail.

When I make the selection, only the first 255 characters are brought into
the text box in Form 2. It is based on a memo field and is set to Can Grow.
when I look at the query for the combo box, all the text from the original
e-mail is there.

I found a response from Allen Browne to a post about the same problem with a
report. From that post, here are the things I have checked:
1) the query does not include the Distinct keyword (Unique Values are set to
no in query properties)
2) there is nothing in the Format property of either of the two text boxes
(Form 1 and Form 2) or of the memo fields in the two underlying tables
3) the detail section of both forms is set to Can Grow

The body control on both forms will accept all the text. I can paste the
e-mail body into Form 2 and fire the Send Object code and everything appears
in the Outlook e-mail.

Is there anything else I can try?
Click to expand...
Click to expand...
 
Back
Top