www.webdeveloper.com
Results 1 to 3 of 3

Thread: Text Control for Access

  1. #1
    Join Date
    Sep 2005
    Location
    UK
    Posts
    65

    Text Control for Access

    Hello there

    I wonder if someone can help…

    Basically I am pulling text out of an Access Database to be displayed on my page. As this text contains more than 255 characters I have changed the field to a ‘memo’ field as opposed to a ‘text’ field.

    It seems to pull the information out fine, but how would I insert paragraphs and control the text how I want it on the page?

    Could an alternative be including a text file, but again, how do I break the text into paragraphs?

    Thanks in advance…

  2. #2
    Join Date
    Dec 2005
    Location
    Blackpool, UK
    Posts
    172
    Enter the text into your memo field in HTML format with tags in place.
    This way when you Output the text it will come out exactly as you want it.....
    "To steal ideas from one person is plagiarism; to steal from many is research."

  3. #3
    Join Date
    Jan 2003
    Location
    USA
    Posts
    688
    Here's what works for me (although I usually put it into its own function):

    ' Fix HTML.
    varFld = Server.HTMLEncode(varFld)

    ' Convert each space and space to space and  
    varFld = Replace(varFld, " ", "  ")

    ' Convert all vbCrLf to <br>.
    ' (This is the same as converting Chr(13) & Chr(10) to <br>.)
    varFld = Replace(varFld, vbCrLf, "<br>")
    J. Paul Schmidt
    www.Bullschmidt.com - Freelance Web and Database Developer
    www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles