Results 1 to 4 of 4

datasheet formatting

  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    722

    datasheet formatting

    Hi all, I'm using Access 2016. I have a form and a subform. Is there a way to change the label color for the txt fields..I changed the Font and the height but only see a way to change all the Font color
    Code:
     me.datasheet.font color = 255
    Any ideas? Thanks

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,194
    AFAIK, no. But you can if you switch to continuous form view. Alternatively, put datasheet on main form as a sub form and put labels above datasheet controls on main form. User can alter width of datasheet column, so they may no longer line up. Or maybe switch to split form. Split has limitations and may not be suitable for you.
    Last edited by Micron; 06-14-2019 at 12:27 PM. Reason: added info
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,207

  4. #4
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    722
    I'll look and let you know.

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

Similar Threads

  1. Datasheet formatting
    By DeeCee in forum Forms
    Replies: 6
    Last Post: 11-26-2018, 12:15 PM
  2. Datasheet Formatting Limitations
    By pdowg881 in forum Access
    Replies: 2
    Last Post: 03-22-2016, 06:09 PM
  3. Conditional Formatting in Datasheet View
    By MatthewGrace in forum Forms
    Replies: 2
    Last Post: 11-02-2014, 03:39 PM
  4. Replies: 1
    Last Post: 04-24-2013, 08:51 PM
  5. COnditional Formatting on a Datasheet
    By anoob in forum Access
    Replies: 2
    Last Post: 02-28-2011, 12:48 AM

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