accessman2
Registered User.
- Local time
- Today, 11:51
- Joined
- Sep 15, 2005
- Messages
- 335
Hi:
I know that "ALTER Table [Table Name] ALTER Column col1 TEXT" can change datatype.
But, can DAO - TableDefs to change datatype of the fields?
i=0
Do While i <= tbl.Fields.count - 1
If (tbl.Fields(i).Name = "Codes") Then
tbl.Fields(i).Properties("DataType").Type = dbText
End If
i = i+1
Loop
Please let me know, thanks.
I know that "ALTER Table [Table Name] ALTER Column col1 TEXT" can change datatype.
But, can DAO - TableDefs to change datatype of the fields?
i=0
Do While i <= tbl.Fields.count - 1
If (tbl.Fields(i).Name = "Codes") Then
tbl.Fields(i).Properties("DataType").Type = dbText
End If
i = i+1
Loop
Please let me know, thanks.