Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Resize field columns 1
- Thread starter vlq0n0
- Start date
-
1
- #2
You can do this with two queries, but not, I think, with one. Having created the table with the make table query, Alter Table can be used to resize columns. For example:
[tt]strSQL = "Alter table tblTable Alter column Field1 Char(150)"
CurrentDB.Execute strSQL[/tt]
[tt]strSQL = "Alter table tblTable Alter column Field1 Char(150)"
CurrentDB.Execute strSQL[/tt]
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question