Bill Benson (vbacreations)
vbacreations at gmail.com
Mon May 17 19:33:31 CDT 2010
Any chance you can use a 2nd invisible text box (make it visible when you need it) if a test of the length of the displayed string exceeds some limit which you deem to approximate slightly less than 64K worth of text? Watch out this is not tested... Str1 = Left (LongString, SomeNumber) 'End on a space Str1 = Left(Str1, instrRev(Str1,Chr(32)-1)) Txt1 = Str1 If Len(LongString) - Len(str1) > 1 then Str2 = Right(LongString, Len(LongString)- Len(str1) - 1) Txt2.Visible = True Txt2 = Str2 Else Txt2 = "" Txt2.Visible = False End If Bill -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, May 17, 2010 7:49 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Really long memo fields There is a 64K character limit on the content of a textbox so even if you store it, you can't display it. (and a label is limited to 2048 characters). There's a list of limitations here: http://www.databasedev.co.uk/access_specifications.html (at least for A2K3). I use Rusty's method in these situations. A continuous form of separate comments each one date/time stamped. In many cases I add another field as well, containing the logon name of the user creating the comment. That way you can filter/sort all of that user content by creator and/or date time very easily. -- Stuart On 17 May 2010 at 18:03, Drew Wutka wrote: > My first question is do you really have a user TYPING in 65k+ of text > into one field? Sheesh! > > I do not believe there is anything special to add more than 65k to a > memo field. I believe you can just open a recordset, and set a memo > field to whatever value you want, up to the size limit of the .mdb. But > I have never looked into whether or not there is a limit to the size of > a textbox. > > Here's a spec on the memo field: > http://www.mvps.org/access/general/gen0011.htm > > Drew > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2875 - Release Date: 05/17/10 02:26:00