Updating and Adding large amounts of text in a field

Results 1 to 4 of 4

Thread: Updating and Adding large amounts of text in a field

  1. #1
    Join Date
    Dec 1969
    Posts
    94

    Default Updating and Adding large amounts of text in a field

    I&#039m trying to update or even add large amounts (article size) of text into an Access field, but it seems like it&#039s limiting me, how do I get around this?

  2. #2
    Join Date
    Dec 1969
    Posts
    69

    Default RE: Updating and Adding large amounts of text in a field

    Set field type in Access to memo insted text. That should do (unless you text is lager of 32000 characters).<BR><BR>stevang@mail.com

  3. #3
    Join Date
    Dec 1969
    Posts
    94

    Default RE: Updating and Adding large amounts of text in a field

    The field is memo, the problem is that the update query i&#039m running won&#039t update with apostrophes (&#039) or commas (,). Is there a way around this?

  4. #4
    Shawn Clabough Guest

    Default RE: Updating and Adding large amounts of text in a field

    Replace the apostrophes with two apostrophes by using the function: strMemo = Replace(Request.form("strMemo"), "&#039", "&#039&#039")<BR><BR>Commas should not be causing a problem.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •