too many fields on form

Hi all...ok I have created a form to use but it is saying
i have too many fields on my form, I am unable to delete
any of the current fields because they are all valid. I
have also looked into using subform but when I am using
the 5 tables the relationships don't work properly, any
ideas?? thanks

Why would you need a form with 754 controls on it? Is the form used to
update or change data? If it only displays data could you combine some of
the fields into a text field? For example, the three fields (city, state,
and zip) could be combined in one text fielde as...

=[city] & ", " & [state] & " " & [Zip]



Note: The limit includes any controls that have been placed on the form in
the past and then deleted. If you modify the design of the form a lot, you
could hit the limit even though you only have a couple hundred controls on
the current version.

To reset that "historical" count, copy and paste the form to a new form in
your database and delete the old copy.

Rick B


"Bran" wrote in message
...
Hi all...ok I have created a form to use but it is saying
i have too many fields on my form, I am unable to delete
any of the current fields because they are all valid. I
have also looked into using subform but when I am using
the 5 tables the relationships don't work properly, any
ideas?? thanks