Subform

How can I add more fields when the subform is full?

Thanks,

If you add fields to the table or query that feeds the subform, then you can
add the additional fields in design view. They will show up in your field
list.
--
Milton Purdy
ACCESS
State of Arkansas


"Fly Boy 5" wrote:

How can I add more fields when the subform is full?

Thanks,

What do you mean by "full"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Fly Boy 5" wrote in message
...
How can I add more fields when the subform is full?

Thanks,

I have no more room to add additional fields.

Thanks,

"Jeff Boyce" wrote:

What do you mean by "full"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Fly Boy 5" wrote in message
...
How can I add more fields when the subform is full?

Thanks,


.

On Mon, 11 Jan 2010 17:09:01 -0800, Fly Boy 5
wrote:

I have no more room to add additional fields.

A Form is limited to 22" by 22"... and controls can be made very small by
using tiny fonts. You have NOT run out of room unless you're using room very
inefficiently. You are limited to (if I remember correctly) 768 controls on a
Form, but you can have multiple Subforms each with its own 768 controls.

And if you have so many controls that this is a problem, you're abusing your
users! Humans have a finite attention capacity.

What is this application? What is the form's Recordsource? How many fields do
you have in the table, and how are you trying to display them? More info
please.
--

John W. Vinson [MVP]

Please review John V's assessment...

If your form/subform have that many controls on them, your users probably
won't use (or want to use) the forms.

As a potential alternative, you can effectively "stack" controls by using
the tab control to hold multiple pages, each page consisting of a set of
related controls.

Good luck!

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Fly Boy 5" wrote in message
...
I have no more room to add additional fields.

Thanks,

"Jeff Boyce" wrote:

What do you mean by "full"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Fly Boy 5" wrote in message
...
How can I add more fields when the subform is full?

Thanks,


.