Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Changing Font size on Datasheet

Posted on 2011-03-25
6
Medium Priority
?
1,004 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
6 Comments
 
LVL 19

Accepted Solution

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

Go to the Home Tab -> Text Formatting Group

Sincerely,
Ed
0
 
LVL 58
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 58

Assisted Solution

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

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

JimD.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 800 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

972 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