The Description property doesn't actually exist until you add a description.
If you try to refer to the Description property before then, you'll get an
error 3270 (Property Not Found)
You can use the CreateProperty method to add it in the first place.
Here's some untested air-code that should create the description if itReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11046
doesn't exist, or change it if it does.
Sub SetDescription(WhatField As DAO.Field, NewDescription As String)
On Error GoTo Err_SetDescription
Dim prpDesc As DAO.Property
WhatField.Properties("Description") = NewDescription
If Err.Number = 3270 Then
Set prpDesc = WhatField.CreateProperties( _
MsgBox "Error " & Err.Number & " (" & _
Err.Description & ") occurred."
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Kate" wrote in message
> Hi, I'm trying to update a tabledef programatically, using
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11046
> field descriptions that exist as text in another table. I
> can't find anyway to set or reference the field's
> description property via VBA. Is this possible?