Is there a way under the "define database" option to change multiple field types at once. I want to change around 30 text fields to Numeric only fields. Ive tired selecting multiple fields by holding down shift, but it will not let me change their "field type" options. Anyone know of another way?

You might be able to do something with AppleScript. Are these really number fields? If they are not used in some mathematical manor they proble should remain text.

Yes these fields should only contain numbers and never text. If someone entered text into these fields by accident it would make the worksheet invalid.

It's not the most elegant solution, but I use macros all the time for this type of work. There are several good and free macro programs out there, so take you pick.

One word of caution using macros, though - try to 'record' your macro using only keyboard commands. I've noticed that playback of mouse commands at faster than 100% sometimes causes problems. This may just be due to the macro program that I'm using.