Results 1 to 7 of 7
  1. #1
    Bospeentje is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2014
    Posts
    15

    change layout datasheet

    Dear members,



    Does anyone know if thereīs a way to change the layout of a datasheet form? I mean font type etc.


    Thanks in advance!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In access options, set datasheet font.
    Or
    in a form, set form style to datasheet, set font.
    or a temp way,
    open sheet, select all, set font.

  3. #3
    Bospeentje is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2014
    Posts
    15
    Sry, I canīt get this to work… whatever I do, everytime the font type of the datasheet form turns to the standard Calibri 11.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Adding a little more detail to Ranman's comments:

    If you set the default in Access options, it will apply to all datasheets UNLESS individually set to be different

    If you want to change an individual datasheet, you can change the font colour, style, colour, size from ribbon for the Home tab.
    You can also change the background colour. alternate row colour & more... AND if you're not careful create a truly hideous outcome
    Make sure you SAVE before closing or it will revert to the default next time it is opened
    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

  5. #5
    Bospeentje is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2014
    Posts
    15
    Thanks for your answers, but it's no help.
    I know how to change the font type and size, but whatever I choose and save(!), the datasheet form is Always shown in Calibri 11.
    It's a known Access bug and I also know there's a way to get around it (thought I read about it on this forum), but forgot the method
    I find it strange though that you both don't seem to recognize this as a bug…..

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I hardly ever use datasheets but i’ve never experienced this issue nor even heard of it before.
    Suggest looking at the DevHut website as the owner often deals with workarounds to bugs

    If it’s that well known an issue, he may have covered it
    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

  7. #7
    Bospeentje is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2014
    Posts
    15
    Found it!
    My datasheet form was a pop up form... changing fonts in that mode doesnīt work!
    Thanks for your help.

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

Similar Threads

  1. GUI type form Layout Change
    By sgthuth in forum Database Design
    Replies: 16
    Last Post: 12-13-2017, 10:24 AM
  2. Replies: 2
    Last Post: 03-14-2017, 09:17 AM
  3. Change the layout of the data in my query
    By Carla C in forum Queries
    Replies: 9
    Last Post: 07-13-2012, 08:42 AM
  4. Replies: 9
    Last Post: 07-11-2012, 04:13 PM
  5. Change of report layout
    By funsofinnih in forum Reports
    Replies: 1
    Last Post: 01-24-2012, 07:18 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