Number of field in form

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

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.
--
Dave Hargis, Microsoft Access MVP


"Camaxtli" wrote:

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

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

Good catch, Linq. I didn't think of that.
Sometimes, things are so obvious you forget to mention them.
--
Dave Hargis, Microsoft Access MVP


"Linq Adams via AccessMonster.com" wrote:

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

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

"Klatuu" wrote:

Good catch, Linq. I didn't think of that.
Sometimes, things are so obvious you forget to mention them.
--
Dave Hargis, Microsoft Access MVP


"Linq Adams via AccessMonster.com" wrote:

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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1