Truncated Memo box on a form-- PLEASE HELP

[Krista]

Hi,
I have tried just about everything that I can find online and nothing seems
to work. I have a memo box on a form that is truncated at 255 characters.
There is no format set on the table or the query (it's a select query). The
memo box has been added from the Field List, that didn't work. It's been
added as a text box and then the control set to the name of the field and
that didn't work either. I'm not sorting, grouping by or anything on the
query. It's a very simple setup so I'm at a loss as to what's wrong.
If anyone has any ideas I would really really appreciate it.
Thanks,
krista

 

[Rick Brandt]

Hi,
I have tried just about everything that I can find online and nothing
seems to work. I have a memo box on a form that is truncated at 255
characters. There is no format set on the table or the query (it's a
select query). The memo box has been added from the Field List, that
didn't work. It's been added as a text box and then the control set
to the name of the field and that didn't work either. I'm not
sorting, grouping by or anything on the query. It's a very simple
setup so I'm at a loss as to what's wrong.
If anyone has any ideas I would really really appreciate it.
Thanks,
krista

Is the text truncated when you look directly at the query's datasheet?

 

[Krista]

Hi Rick,
No it isn't truncated when I look at it in the query. It is only cut off
when I look at it on the form. I can type in past 255 characters, but when I
save it and go back to look at it, it appears to be cut off.

Thanks,
krista

 

[Krista]

Hi,
I don't know if this has anything to do with it, but the way the form is
setup is that when the user clicks on a line in a list box, the fields above
in the form populate. Could this have anything to do with why I can only see
the first 255 characters?

thanks,
krista

 

[Ken Snell \(MVP\)]

If the "memo" field data is coming from a column in the listbox, then yes
that is the source of the truncation. Text strings in a column of a listbox
or combobox are truncated to 255 characters.