Results 1 to 8 of 8
  1. #1
    deepaksharma is offline Competent Performer
    Windows 7 32bit Access 2016
    Join Date
    Jul 2023
    Location
    india
    Posts
    389

    Which is best font ?

    Which font is best for display in text box or drop down list in MS Access form ?

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    That's a bit like asking what's your favourite colour. Then would you buy a car, coat, or house painted in it. Probably not all three.

    A lot depends on size, background colours, purpose of the text.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    5,007
    I have never ever changed the font from what was supplied for dropdown/listbox
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,991
    Agree with the previous comments. There are plenty of fonts that would be terrible but several that work perfectly well according to user preference.
    For the last 15+ years, I have used the default font Calibri and it works fine as far as I'm concerned.
    However in the next month or so, the default in Office 365 will change to Aptos - it looks similar and you might not notice the difference. Its probably already listed as available in your font list.
    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
    Edgar is online now Competent Performer
    Windows 8 Access 2016
    Join Date
    Dec 2022
    Posts
    274
    Depends on the context. Here's a few things to consider in general:
    - Is easy to read

    - It goes well with the general feel of the app. If it's a formal app with tame colors and serious look, I'd expect a formal font, like Times New Roman, which is very angular and elegant, or Arial. If it's an informal kind of app, with curves, round shapes, bright colors, etc, I'd expect a font with more curves than corners, like, say Segoe UI or Century Gothic, even Comic Sans.

    - I'd check if there are characters that don't fit well, like numbers not being at the same height, or several characters looking the same.

    - If you're going to compare lines of text below other lines of text and spacing is important, a monospace font would work well.

    - In the particular case of Access, there's a very annoying issue with some font colors and selections, the default font color, for example, when selected, it shows pixels in other colors. I'd make sure I select a color that does not produce this effect, like pure colors or others that do not produce that effect, I like using 0,128,255, for example, it gives me a nice blue that can be selected without this effect being too noticeable. Check the attached images, the one at the top is the default and has that weird coloring effect with selections, the one below also has the effect but it's a lot easier to read and it looks better when selected, that's pure black.
    Click image for larger version. 

Name:	xample.png 
Views:	17 
Size:	1.2 KB 
ID:	50670Click image for larger version. 

Name:	xample.png 
Views:	17 
Size:	2.9 KB 
ID:	50671

    There are a ton of fonts online that have a great design and feel, you'd just have to make sure the end user will have the font installed.

  6. #6
    deepaksharma is offline Competent Performer
    Windows 7 32bit Access 2016
    Join Date
    Jul 2023
    Location
    india
    Posts
    389
    thanks for suggestion.
    "Segoe UI" is best font for data entry.
    thanks....

  7. #7
    deepaksharma is offline Competent Performer
    Windows 7 32bit Access 2016
    Join Date
    Jul 2023
    Location
    india
    Posts
    389
    thanks for suggestion..

  8. #8
    deepaksharma is offline Competent Performer
    Windows 7 32bit Access 2016
    Join Date
    Jul 2023
    Location
    india
    Posts
    389
    thanks minty for replay....

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

Similar Threads

  1. Replies: 12
    Last Post: 01-12-2019, 06:02 PM
  2. What's Your VB editor font?
    By Micron in forum Access
    Replies: 5
    Last Post: 10-15-2018, 07:44 PM
  3. Change of Font
    By mick3911 in forum Forms
    Replies: 8
    Last Post: 10-03-2018, 02:17 PM
  4. Replies: 4
    Last Post: 08-03-2014, 10:10 PM
  5. Non-persistent Font
    By mystifier in forum Access
    Replies: 0
    Last Post: 11-22-2010, 01:38 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