<p>I am getting an vba error 3271; Invalid property value.  This happens when trying to append a memo field in a querydef.  Any ideas on how to get around this?</p>

<p>Example:</p>

<pre><code>public sub TestMemoField
    Dim qdf As QueryDef
    Set qdf = CurrentDb.QueryDefs("AppendRecord")
    qdf.Parameters("@SomeBigText").value = string(1000,"A")
    qdf.Execute
end sub  
</code></pre>

<p>Thanks in advance.</p>

Apparently you cannot have a parameter longer than 255 characters (
http://support.microsoft.com/kb/275116
).
It is possible to use a recordset, or to use:
```
```
qdf.SQL="INSERT INTO Sometable (SomeField) Values('" & String(1000, "A") & "')"
```
```