Number of field in form

C

Camaxtli

Is there a maximum number of field that can be put in a form? I created a
form from a query, but there is no field is visible in the normal mode but I
can see them all in the creation mode. Any solution?
PS: I do need those fields :)

Thanks!
Camaxtli
 
K

Klatuu

A form has a lifetime maximum of 754 controls. That include lines, buttons,
text boxes. and every other thing you can put on a form. By lifetime, I mean
that when you add a control, the count increases by one, but if you remove a
control, it does not go down by one.

It is not likely you will hit this maxiimum unless you are doing something
like dynamically adding or deleting controls at runtime. Most likely, there
is something wrong with either your form design or your query. Run the query
by itself to be sure it is working and returning rows. Also, be sure all
your controls have the Visible property set to Yes.
 
L

Linq Adams via AccessMonster.com

If AllowAdditions Property for the form is set to No and there are no records
retrieved by the query (or maybe no records in the table at all yet) the
controls will not appear in form view. If you have records in the table, do
as Dave advised you to and run the query by itself to see if it's returning
any records.
 
K

Klatuu

Good catch, Linq. I didn't think of that.
Sometimes, things are so obvious you forget to mention them.
 
C

Camaxtli

Thank you Linq and Klaatu!

Seems that the problem is mainly from my query, it does not work well...sigh
Back to the drawing board...

Thanks again!
Camaxtli
 
Top