Results 1 to 7 of 7
  1. #1
    chavez_sea is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    105

    Vertical elignment


    Good day,
    I would like to align text in a text box vertical as shown on the word INVENTORY etc. I do not know codes. The attached snip is in word, but I made an access database with the inventory, but would need to keep the format of the form.

    Thanks for your help.


  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,526
    Access reports will turn text vertical, but only 1 way.

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,421
    Code:
    Private Sub Form_Current()
        Inventory.TopMargin = Inventory.Height / 2
    End Sub
    Your Word doc is not attached, but the above should approximate the center alignment.
    The shorter the textbox is, the more the height of the font size influences where the center is approximated.
    If the height of the textbox is too small (or the text font too large), the approximation is way off center.

  4. #4
    chavez_sea is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    105
    I dont know how to use the code. capture.zip would you kindly tell me in detail how to proceed. here is the file.

    Thanks

  5. #5
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,421
    Oh, I see. You want to ROTATE the textboxes 90 degrees to a vertical position. You can only do that in reports. See the Vertical property for textbox and label in the properties OTHER tab. No coding required.
    Last edited by davegri; 07-24-2018 at 02:41 PM. Reason: clarif

  6. #6
    chavez_sea is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    105
    Thanks very much.
    Kind regards

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,991
    You can rotate text vertically on form labels ... but not form textboxes as already stated
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Horizontal instead of vertical
    By UT227 in forum Reports
    Replies: 2
    Last Post: 07-10-2017, 10:25 AM
  2. Vertical line not connecting
    By trident in forum Reports
    Replies: 1
    Last Post: 04-13-2016, 06:32 PM
  3. Missing Vertical Scrollbar
    By JeffChr in forum Forms
    Replies: 2
    Last Post: 11-21-2014, 07:54 AM
  4. Vertical scrollbar in reports
    By Cedarguy in forum Reports
    Replies: 2
    Last Post: 11-07-2012, 03:15 PM
  5. Vertical Fields on Report
    By jocallahan in forum Reports
    Replies: 3
    Last Post: 10-09-2008, 07:22 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