Re: Why does my MEMO field truncate my text?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



On Tue, 31 Mar 2009 13:26:08 -0700, RustyCampbell
<RustyCampbell@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

How do I keep Access from truncating my MEMO fields in a data entry form?
When I save the data and then retrieve it for editing, it only brings back
255 characters and then a couple of boxes, along with some other adds and
ends. Sometimes a couple of kana, or the value of one of my control boxes,
etc.

Be sure that there's no Format property on the memo fields or on the form
controls bound to those fields, and that you're not sorting or grouping by the
memo field.
--

John W. Vinson [MVP]
.



Relevant Pages

  • Re: Total character limit on forms?
    ... What restricts GET is size of the environment space on the web server for the process. ... > characters - the limit that can be typed into the browser address bar). ... >> boxes using Frontpage 2000 and set it up to have the server email me the ...
    (microsoft.public.frontpage.client)
  • RE: characters dont print
    ... and all boxes are unchecked! ... I've been able to print out your reply from the Explorer browser ... Font group click the Font dialogue icon in the lower right hand corner. ... doesnt printout the text characters? ...
    (microsoft.public.word.docmanagement)
  • Re: Dynamic or conditional page break?
    ... I have 2 memo fields in my table, and of course I cannot predict how much ... I was thinking that maybe there was a way to put a page break in the report ... the report section that contains the text boxes. ... KeepTogether property may be useful. ...
    (microsoft.public.access.reports)
  • Re: How do I remove "special characters" from cell data?
    ... It's got "boxes" in the street address column. ... Dim myGoodChars As Variant ... Dim iCtr As Long ... Sometimes those funny characters don't work in the edit|Find dialog. ...
    (microsoft.public.excel.misc)
  • RE: Multiple Combo Box Selection
    ... list boxes or combos... ... Dim strError As String ... 'Add it to the predicate- exact match ... 'Add it to the predicate- match on leading characters ...
    (microsoft.public.access.modulesdaovba)