reading values from multiple memo rows into textfield

[de Vroede]

Hi,

I've got a db where I've split users and notes. I did this so I can
have large memo fields (more than 65000 characters). Now I would like
to read (from a query (that works fine)) the values of all memo fields
for that user and show them in a form text field. Is there also a
limitation in the amount of text that a text field can display? And how
can I read these values?
I hope this explaination is clear enough.


regards,

Jeroen

 

[John Nurick]

Hi Jeroen,

An Access textbox is limited to 65536 characters (this and other facts
are in the Help topic "Access Specifications"), so it won't be any help
in displaying long strings formed by concatenating the contents of memo
fields.

By the way, the apparent limit of 65536 characters in a memo field is
due to the limitation of the Access textbox. According to the
specifications, the field itself can store up to a gigabyte (though in
practice the 2 gigabyte limit on the size of an mdb file makes this of
limited practical value).

But the Windows rich text control (RTF control) doesn't have the
65536-character limit so may be the solution to your problem. To use
this in Access without great complication you need a third party
control, e.g. the commercial Total Access Memo from www.fmsinc.com and
the free one from www.lebans.com.