Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Print out of line (Outlook 2000)

    Hi

    I have a report which looks fine on screen but when I print the text is right on the edge of the boxes, these are look up boxes.

    Is there a way to make sure they print in the centre of the box.

    Thanks in advance

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print out of line (Outlook 2000)

    Do you have the text centered on those controls on the report? What does Outlook have to do with it?
    Charlotte

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Print out of line (Outlook 2000)

    Hi Charlotte

    Yes the print is set to centre.

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Print out of line (Outlook 2000)

    Hi Charlotte

    You see my signature well I am a fool were talking Access 97 here.

    My apologies

    Braddy
    If you are a fool at forty, you will always be a fool

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print out of line (Outlook 2000)

    OK, then. what do you mean by lookup boxes? Are you talking about comboboxes? They aren't generally used on reports but are frequently used on forms. If you have controls of the same width and each control (not field, please note) has its text align property set to center, they should all center.
    Charlotte

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Print out of line (Outlook 2000)

    Hi Charlotte

    Sorry if don't explain myself very well I have attached a screen shot of the fields I am reffering to. As I show in my first screen shot the text aligns centre horizontaly but I also would like it align verticaly so that it appears in the centre of the box and not clinging to to the top of the box.

    Hope this is clear I hate to think I am wasting your valuable time. Please forgive an old man.

    Braddy
    If you are a fool at forty, you will always be a fool

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Print out of line (Outlook 2000)

    Unfortunately there isn't a property that will let you change the vertical alignment of a text box or a combo box. You can change the font, the size of the control, and the size of the text and get some control, but Access ultimately decides how far down from the top the text will start.
    Wendell

  8. #8
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Print out of line (Outlook 2000)

    Hi Wendell

    Thanks for the info, Like death and taxes I shall have to learn to live with it.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  9. #9
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Print out of line (Outlook 2000)

    I'm not sure if it's a form or report you're dealing with. In any case, in A2K or later, a textbox on form or report has a Top, Bottom, Left, and Right Margin property (Format tab on Property sheet) that can be used to modify its appearance. As noted previously, there is no "vertical alignment" property you can set for text or combobox. However, for textboxes, you can experiment with Top Margin property (normally would be set to a small value, like 0.025, depending on size of textbox) to try to "center" text vertically in the textbox. A combobox does not have these margin properties, so I don't know of a good way offhand to prevent the text from "clinging" to top of combobox.

    HTH

  10. #10
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Print out of line (Access 2000)

    PS: If you really want to, you can fool around with some of the combobox Format properties to make the text look vertically centered. See attached screen shot. To attain this effect, set the combobox Special Effect property to "Flat", and set Border Width property to something like 2 or 3 pt or higher, and Border Color to same color as combobox Back Color property. Then add a Rectangle (Box) control to form, so that it surrounds border of the combobox. Recommend use Format "Send to Back" command to send Rectangle "behind" the combobox so it doesn't "block" the combo's ControlTip (if it has one). Then set Rectangle's Special Effect property to "Sunken" for 3-D effect. You may have to play around with the size settings for both controls to make it look right. One drawback, if border too wide, the drop-down box (with arrow) will look too small. Otherwise, combobox functions normally. You can experiment with the settings to get it to look how you want. Note: if it's a report you're working with, the combobox serves no purpose, I'd change it to a textbox, then use Top Margin property as previously described to center text.

    HTH
    Attached Images Attached Images

  11. #11
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Print out of line (Outlook 2000)

    Hi

    It has to be combo box to make selection easy, It's easier to live with the out of alignment than to spend time having to type everything into a text box, It's only my pedancy that made me ask this question in the first place.

    Many thanks for your reply

    Braddy
    If you are a fool at forty, you will always be a fool

  12. #12
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Print out of line (Access 2000)

    Hi Mark

    It's actually on a report where the print is out of line, not on the form.
    Thanks for your reply

    Braddy
    If you are a fool at forty, you will always be a fool

  13. #13
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print out of line (Access 2000)

    I'm confused Braddy... How are you making ANYselection on a report?

    If the report is coming from a form's data, why not just make an invisible text box on the form, make it hold the combobox's selected value, and then use the text box on the report? .... Just a thought... <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Print out of line (Outlook 2000)

    As Alexya1 wrote, there is no obligation to use a combo box on a report if you use a combo box on the corresponding form. You might as well use a text box, since the dropdown part won't work in a report anyway. If necessary, adapt the record source of the report to make the text box display the correct info.

    By the way, your screesnhots show that the label and combo box use the same font/font size on your form, but different ones on the report. It is very difficult to make controls with different fonts/font sizes line up exactly.

  15. #15
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Print out of line (Access 2000)

    Hi Alexya1

    It's so simple I can't believe I didn't think of it.

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •