Andy wrote:
> Thanks Guys
> Each of the fields is a possible reading from a test result. Not all fields
> need to van a value, but the option has to be available.
> For instance, the user would enter his/her test results in to the relevant
> text fields. Not all results will have all values.
> Each text field is a unique reading and not duplicated in the database.
> I should be using MSSQL i know, but i have yet to make the leap and my
> knowledge is limited where MSSQL is concerned.
>
> Thanks for the advice

You would have the same problem with MSSQL, as its ADO that has the
field limit, not the database.

Steve