Changing field size

  • Thread starter Thread starter reidarT
  • Start date Start date
R

reidarT

How can I programmatically change the size of a field in a table from 50 to
255?
reidarT
 
strSql = "ALTER TABLE MyTable ALTER COLUMN MyField TEXT(255);"
DBEngine(0)(0).Execute strSql, dbFailOnError
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Size and background on CheckBox 3
Adding a field in a table 1
Size of a file 1
Merge data from Acces to word 1
programatically disable windows in taskbar 1
Change fieldtype 2
Open access-application with fixed size 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top