You know,... you might just have something there.
I just checked I use varchar(25) and varchar(50) and so on. that might just be the trouble.
I might want to change it to char(25) and char(50) etc. what do I care about space most of my files are only a few thousand records !! nothing all that large.

I think the largest tabel is 150,000 records.-but thats all preformatted with only a few fields anyway. should I change them to chars not varchar. ???
Bob



Another note.
I have not used the datasession either. but it might be something to look into... thanks.




>You can preset the control source to the cursors fields, but you will still end up just entering the control sources manually.
>
>I think its better to set all your control sources manually in the init even of your form, so its much easier to find and change the control sources later on.
>
>You might be able to create the cursor at design time and use that as in your data session, although I haven't really used the data session in a long time so it might not work with cursors.
>
>About your field length problem what data type did you set your field in MySQL database?