Access 2000 in form design view footer will not let me drag down

G

Guest

I am in Access 2000 for design view. Access will not let me drag footer down
in order to extend the page and continue inputting design. I have searched
for various ways to find this answer. I've tried single form, continuous
form, auto resize, yes, no, even inserting page break. Even my co-work (who
knows more) is stumped.

Shar
 
G

Guest

Just ta thought

On the view menu make sure that Page or Form header/footer options are
selected
 
G

Guest

Or

You could try and “manually†set the footer size.
Open the report in design view
Select the footer by clicking the line above the footer section
- it has Page Footer or Form Footer written on it)
Open the properties box and set the height to whatever (on the Format column)

Give it a try and let me know if it changes anything
 
G

Guest

Both are check view. I have tried resizing both Page and form footer from 0
to 2". I even resized the font and srink to fit on my Page header. When you
click page footer it will not drag down. I have Form Propty:
View-Continuous, auto resize - yes. Detail Propty: Force new page - no.
together-no, grow-yes, shrink-yes but noticed height never changed from 22"
even if I try to reset it. I just have Label boxes with a check boxes or
memo boxes on form and page view shows 5 pages.
 
G

Guest

Have you set the "Display When" to Always.

I have tried everything (other than hitting my laptop with a brick) and can
not "brake" the Form and Page footer. They always works. I have even set
the page sige to VERY small, VERY big, Continous, ad every other setting i
can think. till works (at least in design view which is what we are talking
about)

Try createing another (new form) does the same thing happen to the new form.




--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.
 
G

Guest

Hi again

Do you have any code on the form (something like)
If [Name] = "" (or something else) Then
[FormFooter].Visible = False
Else
[FormFooter].Visible = True
End If

Just thought - just a bit of aircode but you never know



--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.
 
G

Guest

Thank you Wayne for trying to help me but I'm still at a loss. Yes the
display is set at Always and I found not codes as you mentioned. I did
decided to start a new form from scratch and this is a really symple set up.
I sat up table with Possible Answers in field and yes/no, text, number in
data field - no other coding. Then I sat form using the answer tbl and putt
labels on form and typed in my Environmental questions. I draged the
page/footer to extend length of "NEW" form and "planned" on putting a enter
key at bottom of question form to advance to next record. Well guess what,
it still only goes to 22" on the ruler. This is in design view with ruler
showing. It always stops at 22" will not go beyound that. Think at this
point, can I put key "next" and start another form that continues. I have
looked at the AYS survey always mentioned here and way above what I know. The
tec school I took Access I & II was like a review of the examples very little
do your own to learn. Everyone left like blank from that class. I just do
not know what else to do unless my Access is corrupted or something. Sorry
this is so long.
--
Shar


Wayne-I-M said:
Hi again

Do you have any code on the form (something like)
If [Name] = "" (or something else) Then
[FormFooter].Visible = False
Else
[FormFooter].Visible = True
End If

Just thought - just a bit of aircode but you never know



--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.



Wayne-I-M said:
Have you set the "Display When" to Always.

I have tried everything (other than hitting my laptop with a brick) and can
not "brake" the Form and Page footer. They always works. I have even set
the page sige to VERY small, VERY big, Continous, ad every other setting i
can think. till works (at least in design view which is what we are talking
about)

Try createing another (new form) does the same thing happen to the new form.




--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.
 
G

Guest

I had a second thought - just to clarify this it the "detail" section where
I'm enter the form information, that when I grab the footer it will not
expand the "detail" beyond 22" not the footer section.
--
Shar


Wayne-I-M said:
Hi again

Do you have any code on the form (something like)
If [Name] = "" (or something else) Then
[FormFooter].Visible = False
Else
[FormFooter].Visible = True
End If

Just thought - just a bit of aircode but you never know



--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.



Wayne-I-M said:
Have you set the "Display When" to Always.

I have tried everything (other than hitting my laptop with a brick) and can
not "brake" the Form and Page footer. They always works. I have even set
the page sige to VERY small, VERY big, Continous, ad every other setting i
can think. till works (at least in design view which is what we are talking
about)

Try createing another (new form) does the same thing happen to the new form.




--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.
 
J

John Nurick

Hi Sharlene,

22 inches is a hard-coded limit on many dimensions in Microsoft Office.
If you look in help for "Access Specifications" you'll find that forms
and reports can't be wider than 22 inches, and that no section of a form
or report can be taller than 22 inches.
 
G

Guest

Thank you John for saving my sanity. I really started think that must be the
deal hear but when my co-worker could not figure it out it made me loose what
little confidence I had working with this program. I have searched under
everything but that. Will try something else as mention before. Thank you
both.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top