By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,361 Members | 3,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,361 IT Pros & Developers. It's quick & easy.

Text to Memo Change Failed

P: n/a
This seems a bit odd and probably I'm overlooking something, but have
not been able to change a text field to a memo one. Of course, I made
the change in the related Table setting, however the display in the
expanded box on the form stops at 255 characters regardless.

The box gets its data from a four column list box and is used for an
expanded report description. And yes, I tried changing the list box
to "memo" as well, but to no avail. I have a basic secondary form for
inputting the report description and other information and after
changing this form from text to memo it worked. But as mentioned, the
display of the description in the box on the my report selection form
stops at 255 char.

Any suggestions anyone?

Thanks, Dalan
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ot***@safe-mail.net (Dalan) wrote in
news:50**************************@posting.google.c om:
This seems a bit odd and probably I'm overlooking something,
but have not been able to change a text field to a memo one.
Of course, I made the change in the related Table setting,
however the display in the expanded box on the form stops at
255 characters regardless.

The box gets its data from a four column list box and is used
for an expanded report description. And yes, I tried changing
the list box to "memo" as well, but to no avail.

List boxes implicitly convert memo to text.
I have a basic secondary form for inputting the report description and
other information and after changing this form from text to
memo it worked. But as mentioned, the display of the
description in the box on the my report selection form stops
at 255 char.

Any suggestions anyone?
Bind your textbox to the table. Goto the applicable record in the
afterupdate event of the listbox.

Thanks, Dalan


Nov 12 '05 #2

P: n/a
Bob Quintal <bq******@generation.net> wrote in message news:<76******************************@news.terane ws.com>...
ot***@safe-mail.net (Dalan) wrote in
news:50**************************@posting.google.c om:
This seems a bit odd and probably I'm overlooking something,
but have not been able to change a text field to a memo one.
Of course, I made the change in the related Table setting,
however the display in the expanded box on the form stops at
255 characters regardless.

The box gets its data from a four column list box and is used
for an expanded report description. And yes, I tried changing
the list box to "memo" as well, but to no avail.

List boxes implicitly convert memo to text.
I have a
basic secondary form for inputting the report description and
other information and after changing this form from text to
memo it worked. But as mentioned, the display of the
description in the box on the my report selection form stops
at 255 char.

Any suggestions anyone?


Bind your textbox to the table. Goto the applicable record in the
afterupdate event of the listbox.

Thanks, Dalan

Thanks Bob, however, could you share a bit more? The textbox is bound
to the table. What code does one need to insert in the AfterUpdate
event of the ListBox? Dalan
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.