When I run the Forms wizard, I go through and select the fields I want, the background, style, etc...without a hitch. However, when I click "Finish" it thinks and begins to draw the form, but then I get an error message:
"You have selected too many fields. Please try again with fewer fields."
Now nowhere earlier in the wizard does it mention a limit on the number of fields that can be used. Between the Help file and Microsoft online support I've learned that there's a limit of 255 fields for queries and tables, so I assume there's something similar for forms, but I'm only using about 30 fields.
If anyone knows of a way to change or bypass this limit, please let me know, I am quite willing to sacrifice "database performance" if it means I can actually use the form I need to use...
Thanks in advance!
"You have selected too many fields. Please try again with fewer fields."
Now nowhere earlier in the wizard does it mention a limit on the number of fields that can be used. Between the Help file and Microsoft online support I've learned that there's a limit of 255 fields for queries and tables, so I assume there's something similar for forms, but I'm only using about 30 fields.
If anyone knows of a way to change or bypass this limit, please let me know, I am quite willing to sacrifice "database performance" if it means I can actually use the form I need to use...
Thanks in advance!