Alter Table to change Field Datatype

[Guest]

I am amending a field's datatype using the following:

Set db = CurrentDb()
strSQL = "ALTER TABLE TblUserFieldEmployeeDetails ALTER COLUMN " &
fldName & " " & strFieldType
db.Execute strSQL

The datatype has been changed immediately and successfully when I look at
the table in desgin view, but none of the forms will pick up the new datatype
without completely closing the database and reopening it.

Is there a way to reload/refresh the tables without having to exit the
databse?

Many thanks

 

[John Spencer (MVP)]

You might try

Db.TableDefs.Refresh