Hi All.
I know it is a beginner's question but how can I change the fields
properties of many fields in my table at once. I know you can change
them one at a time, but they are so many in my tables. Please help!

Thanks,.

Unfortunately, you have to code each one separately, but you can automate it
using visual basic if you change the same items frequently.

Another option would be to write an sql statement that creates a new table,
then copy data from the old table.

and I'm sure there's other options, there is always more than one solution
to a programmers task.

If you have large tables, consider normalization to consolidate data and
reduce the size

"Fida" <fkanaan (AT) hdrinc (DOT) com> wrote