I seem to have run up against the field limits in Access, to my detriment. Both in tables and forms. It's basically a medical chart summation with lots of variables and no real logical way to break it up into separate tables. I thought about putting it in SQL Server (what we have, no choice there) but there's still the form issue. As it is, I just split it arbitrarily into three tables and have a single form with a tab control containing a couple different subforms with the data from the other tables. Now, of course, some new vars have been added, which means either yeat another table or moving some vars around, blah blah blah, all a PITA.

This is kind of a generalized rant, partly a troll for possible options around the problem in some combination of Access/SQL, and partly a troll for suggestions as to migrating away from Access. We're pretty much bound to SQL for the foreseeable future, and it'll probably be mandated soon to get everything into it for security reasons (I know, I know, you may laugh at that).

So anyway, I'm open to suggestions for moving interface dev out of Access. I still like the environment -- being able to put up a control and not have to write code to make it do every stupid thing -- but it is getting limiting.