Exceeding Limits via Code?

[gemma-the-husky]

@colin

this bit

I would imagine the correct solution is to normalise the data, and present it in another way. Maybe 31 rows of data, and monthly columns, in a continuous form.

was aimed at the @OP

Having hundreds of controls on a from implies it isn't normalised correctly. I thought there ought to be a way of presenting the data better to reduce the number of controls required.

 

[MajP]

Just to be clear, not looking for an alternate approach because there is no problem. Only trying to understand why there is no problem.
Normalization is not an issue because it is a completely unbound form. It is purposely a non-normalized view. It is pulling normalized data and pushing in this format. Also not looking for any fix or alternate means to present this issue, there are many other alternatives. The question was simply about the ability to exceed 754 controls on a form or report. The answer was not code, the answer was that 754 is not the limit and MS has just not updated their list of limitations. It is something around 1015-1040. The other question was why it worked on the form and not the report. I believe there is not an issue, but dealt more with the process of cutting and pasting.

There are other approaches
1. make each month a subform
2. use a xtab
3. use a pseudo grid table and write to that
However, not looking for an alternative just trying to understand if I was exceeding the limit via code. There are some limits than can be exceeded. This was just a mistake in understanding the limit.

 

[The_Doc_Man]

There are some limits than can be exceeded.

Not true. ALL limits can be exceeded. You just have to clean up the mess afterwards.

Heck, even in New Orleans, it IS possible to eat too many boiled, spicy shrimp. Trust me, that's a limit I won't try to exceed again.