Hello, Below is the code I used

[mans]

Hello,

Below is the code I used to create a field within a pre-existing table. Can somebody please let me know what code I should use to change a PRE-EXISTING field data type from dbText to dbMemo without deleting it first (using the table and field below if possible).

Set td = daoDB36.TableDefs("Tale1&quot
Set F = td.CreateField("Comments", dbText)
F.Required = False
td.Fields.Append F

Thank You