Results 1 to 3 of 3

Datasheet Formatting Limitations

  1. #1
    pdowg881 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015

    Datasheet Formatting Limitations

    I'm using Access 2013.

    Is it possible to vertically align text in datasheet cells? Can different columns have different text sizes?


  2. #2
    vicsaccess's Avatar
    vicsaccess is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Apr 2015
    have you tried searching? i found this one from missinglinq

  3. #3
    Ajax is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    the vertical property works for form, but not a datasheet. Datasheets having limited facilities for formatting which affects the whole sheet. However you can make a continuous form look like a datasheet and with some vba create options for resizing etc so you can get access to all the normal form formatting. The only thing you won't be able to do is have rows of different heights - as with a datasheet.

    With conditional formatting you change back and fore colors plus bold/italic/underline which with the right condition can set a whole column, but not font size

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

Similar Threads

  1. Conditional Formatting - Query Datasheet View
    By ryanmce92 in forum Queries
    Replies: 6
    Last Post: 05-20-2015, 02:10 PM
  2. Conditional Formatting in Datasheet View
    By MatthewGrace in forum Forms
    Replies: 2
    Last Post: 11-02-2014, 03:39 PM
  3. Sending datasheet to email loses formatting
    By Kristeen Boyd in forum Import/Export Data
    Replies: 3
    Last Post: 08-29-2012, 05:31 PM
  4. Formatting split form datasheet portion
    By SpaceEd in forum Forms
    Replies: 5
    Last Post: 10-19-2011, 11:40 AM
  5. COnditional Formatting on a Datasheet
    By anoob in forum Access
    Replies: 2
    Last Post: 02-28-2011, 12:48 AM

Tags for this Thread

Posting Permissions

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