R
RobertF
The details section of my form is set at a maximum height of 55 cm? Can I
expand this or can I add a second details section to my form?
expand this or can I add a second details section to my form?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
6
'69 Camaro
Hi, Robert.
One may add the header and footer sections to increase the total height
available, but those sections aren't scrollable, and if one adds enough
height to any of the headers or footers, then the detail section is removed
from view, so it isn't even accessible, let alone scrollable. For an earlier
discussion on this, please see the following Web page:
http://groups.google.co.uk/groups?hl=en&lr=&th=3874526c5602ce1c&rnum=1
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering
The details section of my form is set at a maximum height of 55 cm? Can I
expand this or can I add a second details section to my form?
One may add the header and footer sections to increase the total height
available, but those sections aren't scrollable, and if one adds enough
height to any of the headers or footers, then the detail section is removed
from view, so it isn't even accessible, let alone scrollable. For an earlier
discussion on this, please see the following Web page:
http://groups.google.co.uk/groups?hl=en&lr=&th=3874526c5602ce1c&rnum=1
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering
R
RobertF
Thanks Gunny,
Does this mean that if I am entering a large number of fields, that I need
to put them on separate forms?
Does this mean that if I am entering a large number of fields, that I need
to put them on separate forms?
6
'69 Camaro
Hi, Robert.
If you have a large number of fields, then the first thing to consider is
whether the tables in the database are normalized. A large number of fields
in the table is an indicator that the table may not be normalized.
There are several options, depending upon the best method to logically
organize the data. Subforms can be used on a main form, tabbed pages on a
main form, or even separate forms. How you design the application's
presentation (forms and reports) depends upon the data, the needs of the
organization, and the abilities/skills of the users. Without interviewing
you and your users or seeing your database, it's very difficult to give
anything more than generic advice, because what works well in one
organization may be totally inappropriate in another.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering
Does this mean that if I am entering a large number of fields
If you have a large number of fields, then the first thing to consider is
whether the tables in the database are normalized. A large number of fields
in the table is an indicator that the table may not be normalized.
put them on separate forms?
There are several options, depending upon the best method to logically
organize the data. Subforms can be used on a main form, tabbed pages on a
main form, or even separate forms. How you design the application's
presentation (forms and reports) depends upon the data, the needs of the
organization, and the abilities/skills of the users. Without interviewing
you and your users or seeing your database, it's very difficult to give
anything more than generic advice, because what works well in one
organization may be totally inappropriate in another.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering