dbMemoTextSize

Define memo field display format.

Property Syntax

Obj.dbMemoTextSize = 0|-1|n

Parameters

Parameters

Default Value

Description

n 0
  • 0 = "Memo" (default shows the word "Memo" in the cell).
  • -1 = Entire Memo contents is displayed in the cell.
  • n>1 = Show the first 'n' characters in the cell.

Example

<CENTER><h2>Export Demo</h2></CENTER>
<%
Set X=Server.CreateObject("ASP.DB")
X.dbQuickProps="115;NWIND;employees;Form"
X.dbMemoTextSize=20
X.dbNavigationItem="prev,next"
X.dbFormDisplayFlds="0,1,2,3,Notes"
X.dbexportflds="0,1,(2),notes"
X.dbOptions="ExportMagic=true"
X.dbMagicCell="0,,ID #0#"
X.ASPDB

response.write("<B>Note that Memo are always exported in FULL...</B><BR>")
response.write("* Export - Notes=" & session("aspdb_115_Notes") & "<BR>")
response.write("<B>Note that ExportMagic=true and now exported values are converted values including the HTML Tags except field (2) which exports in RAW.</B><BR>")
response.write("* Export - Last Name=" & session("aspdb_115_LastName") & "<BR>")
response.write("* Export - First Name=" & session("aspdb_115_FirstName") & "<BR>")
response.write("* Export - ID=" & session("aspdb_115_employeeID") & "<BR>")
%>

Output