Results 1 to 8 of 8
  1. #1
    TeaBase's Avatar
    TeaBase is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2013
    Posts
    12

    Question Forms - Using page breaks

    Hello (first post) I'm trying to learn Access at the moment and I'm following a tutorial through, I'm not too sure about a part referring to page break at the moment.



    The tutorial ask's me to put a page break in the following places :



    Which I have done :



    It then goes on to say :



    And displays the window as such :




    However, I can't do this, I think It might be because I'm using tabbed view?



    Do I have to change the windows from tab's to floating window's to follow this method or is there something I'm missing??

    Thank you!

  2. #2
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    I'm not able to read the pictures/links. I also don't use page breaks on forms - generally I find that sequential forms serve the same function and keep the complexity of each form to a minimum. Sorry.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    I have never been able to or desired to adjust a form's height or width that conflicted with the position of a control or label on a form.

    having said that, I do not believe there is a property to adjust the "Form" height. I believe you can adjust the height of Hedars, Details, Footers, etc. You can create a line break, not a page break, by dragging the bottom of the form up and down and saving the form.

    So, even if there was a form height property, I don't see how you would be able to adjust it to match the middle of a control or label's position within the form.

    I guess you could try and place a "Page-Break" in the middle of your control...

  4. #4
    TeaBase's Avatar
    TeaBase is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2013
    Posts
    12
    Quote Originally Posted by ItsMe View Post
    I have never been able to or desired to adjust a form's height or width that conflicted with the position of a control or label on a form.

    having said that, I do not believe there is a property to adjust the "Form" height. I believe you can adjust the height of Hedars, Details, Footers, etc. You can create a line break, not a page break, by dragging the bottom of the form up and down and saving the form.

    So, even if there was a form height property, I don't see how you would be able to adjust it to match the middle of a control or label's position within the form.

    I guess you could try and place a "Page-Break" in the middle of your control...

    Hmm, going by what you two have said this part of the lesson is for al sense and purpose purely theory and (most likely) of very little use! What would you use the page break for generally (If at all!)

    @Dal - not sure why you can't see the images... ? They work fine here :/

    @ItsMe - Yeah, I'm not too sure what the point is, something to do with printing or something.

    this is the reasoning that the tutorial gave


  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Just because you do not see the need for page breaks does not mean your opinion will substitute completing the lesson.

    Yes, you can print a form. I can imagine that page breaks would be nice so the form could be formatted to fit a page. I usually format my forms to fit a screen resolution. If I need to print something, I use a report.

    If my decision to format a form to a specific screen resolution conflicts with business rules, I will employ various controls. A common control would be the tab control.

    For the original thing about form height, I don't understand the question. I am not aware of a literal translation within Access to the question. If I was to guess the translation, I would say the label/control position can not occupy the same coordinates of another control or object property. I suggest you test this theory with your page break.

  6. #6
    TeaBase's Avatar
    TeaBase is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2013
    Posts
    12
    Quote Originally Posted by ItsMe View Post

    For the original thing about form height, I don't understand the question. I am not aware of a literal translation within Access to the question. If I was to guess the translation, I would say the label/control position can not occupy the same coordinates of another control or object property. I suggest you test this theory with your page break.
    Basically It looks at though they've got windows set to floating rather than tabbed (I prefer tabbed) and they've simply resized the actual window that the form is housed in. As mine are tabbed I am unable to do this, I thought that there might be another way to do it.

    From here



    To here



    It seems as though all they have done is resize the window, not edit the height of the Form on Form Properties.

    Is that right... ? I'm having trouble following it.

  7. #7
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    A tab control allows you to place other controls inside of it. The tab control is a special control that helps the designer manage real estate. You can place many controls within the tab control. When you run out of space and need to add many more controls, you add an additional tab to the existing tab control. You can also have multi row tab controls. It is a control. Another control that Access offers is the Navigation control. I am not a big fan of the Navigation Control but it does a similar thing. It manages the screen real estate.

    When you resize the "Window", you are not changing the width or height of the form. You are changing the Window size. Stay focused on the form part. There is a scale you can view. If you adjust the width of the form, the value of the form's width will change relative to the scale. The window size will not affect how the form prints or if it will print on one or many pages.

    Try placing your page break along side the control mentioned within your lesson. This is the only thing I can imagine the lesson is asking you to do. I believe the page break behaves like a control. If you place it in an area that conflicts with another control, you may get an unfavorable result in print preview or if you were to print the form or you were viewing the form and tabbing to different breaks.

  8. #8
    TeaBase's Avatar
    TeaBase is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2013
    Posts
    12
    A tab control allows you to place other controls inside of it.


    I used a tab control earlier, (but it didn't suggest one for this part) :




    When you resize the "Window", you are not changing the width or height of the form. You are changing the Window size.


    That's why I thought It seemed odd

    Try placing your page break along side the control mentioned within your lesson. This is the only thing I can imagine the lesson is asking you to do


    I've tried this to the best of my understanding



    I thought there might have been something obvious, sorry. I'll keep going on with the tutorial and maybe when I come back to this part something will click

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Page Breaks
    By Talayoe in forum Reports
    Replies: 2
    Last Post: 11-26-2012, 11:20 AM
  2. Dynamic Page Breaks in Reports using VBA
    By EddieN1 in forum Reports
    Replies: 1
    Last Post: 08-16-2012, 11:59 AM
  3. Page Breaks and the Report Footer
    By dssrun in forum Reports
    Replies: 4
    Last Post: 05-03-2011, 03:23 PM
  4. Page breaks
    By berni3883 in forum Reports
    Replies: 0
    Last Post: 03-31-2011, 01:25 PM
  5. Page Breaks. Is there a way to do it?
    By newtoAccess in forum Reports
    Replies: 8
    Last Post: 11-30-2010, 01:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums