Solved

Changing Font size on Datasheet

Posted on 2011-03-25
6
984 Views
Last Modified: 2012-05-11
Hi,
I am using Access 2010.
Simple question: How do I change font size for the body of a datasheet??

There is a button at the top of the screen that allows me to change to Fonts but NOT the size - just the style.

In the "Design" form there is no font size either.  (Unlike regular forms)

Am I missing something?
0
Comment
Question by:Patrick O'Dea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 19

Accepted Solution

by:
MINDSUPERB earned 250 total points
ID: 35213547
Open the form in Normal View then

Go to the Home Tab -> Text Formatting Group

Sincerely,
Ed
0
 
LVL 57
ID: 35213551

 Click File, then options.  Look on the left for datasheet.  The font size option is to the right.

JimD.
Window-Capture.jpg
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 50 total points
ID: 35213555

 Sorry, I was thinking of the default.  Ed is correct.

JimD.
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 75
ID: 35216728
You can do this in the Form Load event, as well as set other Datasheet properties.

mx
Capture1.gif
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 200 total points
ID: 35216740
This is a good reference also:

'Michael Kaplan Smart Access article:
You Can Do That with Datasheets
http://msdn2.microsoft.com/en-us/library/aa217449.aspx   

mx
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 35217135
Thanks again ... I will now check out MX article!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question