---
title: "ActualSize and DefinedSize Properties Example (JScript) | Microsoft Docs"
ms.prod: sql
ms.prod_service: connectivity
ms.technology: connectivity
ms.custom: ""
ms.date: "01/19/2017"
ms.reviewer: ""
ms.topic: conceptual
dev_langs:
- "JScript"
helpviewer_keywords:
- "ActualSize property [ADO], JScript example"
- "DefinedSize property [ADO], JScript example"
ms.assetid: 23575e70-2304-43b4-b8be-99d9a6842589
author: MightyPen
ms.author: genemi
---
# ActualSize and DefinedSize Properties Example (JScript)
This example uses the [ActualSize](../../../ado/reference/ado-api/actualsize-property-ado.md) and [DefinedSize](../../../ado/reference/ado-api/definedsize-property.md) properties to display the defined size and actual size of a field. Cut and paste the following code to Notepad or another text editor, and save it as **ActualSizeJS.asp**.
```
<%@LANGUAGE="JScript" %>
<%// use this meta tag instead of adojavas.inc%>
ActualSize and DefinedSize Properties Example (JScript)
ADO ActualSize and DefinedSize Properties (JScript)
<%
// connection and recordset variables
var Cnxn = Server.CreateObject("ADODB.Connection")
var strCnxn = "Provider='sqloledb';Data Source=" + Request.ServerVariables("SERVER_NAME") + ";" +
"Initial Catalog='Northwind';Integrated Security='SSPI';";
var rsSuppliers = Server.CreateObject("ADODB.Recordset");
// display variables
var fld, strMessage;
try
{
// open connection
Cnxn.Open(strCnxn);
// Open a recordset on the stores table
rsSuppliers.Open("Suppliers", strCnxn);
// build table headers
Response.Write("");
Response.Write('| Field Value | ');
Response.Write("Defined Size | ");
Response.Write("Actual Size |
|---|
");
while (!rsSuppliers.EOF)
{
// start a new line
strMessage = '';
// Display the contents of the chosen field with
// its defined size and actual size
fld = rsSuppliers("CompanyName");
strMessage += '| ' + fld.Value + " | "
strMessage += "" + fld.DefinedSize + " | ";
strMessage += "" + fld.ActualSize + " | ";
// end the line
strMessage += "
";
// display data
Response.Write(strMessage);
// get next record
rsSuppliers.MoveNext;
}
// close the table
Response.Write("
");
}
catch (e)
{
Response.Write(e.message);
}
finally
{
// clean up
if (rsSuppliers.State == adStateOpen)
rsSuppliers.Close;
if (Cnxn.State == adStateOpen)
Cnxn.Close;
rsSuppliers = null;
Cnxn = null;
}
%>
```
## See Also
[ActualSize Property (ADO)](../../../ado/reference/ado-api/actualsize-property-ado.md)
[DefinedSize Property](../../../ado/reference/ado-api/definedsize-property.md)
[Field Object](../../../ado/reference/ado-api/field-object.md)