By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

How to change the font size of a subform: datasheet view.

P: 31

I have a form with a subform set to datasheet view, but i'm running out of real estate, so I just want to shrink the font. I've scoured boards and nothing seems to be working. I've tried:

1.) Access Ribbon-->Access Options-->Datasheet This changes all font sizes of my tables and queries, but not my forms set to datasheet view.

2.) I've opened the subform as its own form, selected Layout View, selected my text boxes, and changed it up in the Format tab of the Ribbon. This changes its appearance in Layout view, but when I switch back to datasheet view, no dice.

3.) All manner of right-clicking-->properties madness.

Notably, after completing #1, I can recreate the subform with the wizard and it displays according to those settigns. So that's a work around, but I want to know, deep down, where my original form is holding onto this setting.

Mar 6 '14 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
Appears that we missed your question.

I've tried a few different methods and in each case was able to set the font style and size as needed.

In ACC2010:
Open the subform directly.
Open it's properties.
Set the default view to datasheet.
Close the form
Open the parent form
Click into the subform
Select the home tab in the ribbon
Set your font and size there
Close the parent form
Save the form layout when prompted.

From my testing, this will effect only the currently open and selected subform.
Apr 21 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.