Access Memo Field and Null Problems

Results 1 to 2 of 2

Thread: Access Memo Field and Null Problems

  1. #1
    Jaco SA Guest

    Default Access Memo Field and Null Problems

    I&#039m working on an app that takes an Access memo field via ADO recordset and displays the info. The problem is:<BR><BR>The memo field is split into several sections eg<BR><BR>upper:Upper text go here (vbcrlf)<BR>lower:Lower text go here (vbcrlf)<BR><BR>I can&#039t parse the field for the relevant information.<BR>Using len or mid or cstr in ASP VBScript all return invalid use of null.<BR><BR>(PS. The same code works 100% in Visual Basic?)<BR><BR>Any ideas??<BR><BR>Jaco SA

  2. #2
    Michael Swanson Guest

    Default RE: Access Memo Field and Null Problems

    You could check to see if the value is null before you process it with:<BR><BR>If Not IsNull(Field) Then<BR><BR> &#039Process field information<BR><BR>End If<BR><BR>Michael Swanson, MCSE, MCP+Internet<BR>Webmaster<BR>Donnelly Corporation<BR><BR><BR>

Posting Permissions

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