Change Font Size in a subform set in datasheet view

[chrisjames25]

Hi I have a subform that is set as datasheet view.

I have run out of room so need to shrink the font a bit to get all my columns in but cant seem to figure out how to shrink the font.

I change font size in subform properties but when switch to datasheet it just stays as standard size font.

Any ideas greatly appreciated.

 

[chrisjames25]

THe home ribbon is all greyed out where you would usually adjust the font size for a datasheet table or query

 

[arnelgp]

Open the subform in datasheet view and change it there in the ribbon.

 

[missinglinq]

I believe this kind of thing, for a given Form, in Datasheet View, can only be done thru Properties that are exclusive to Datasheet View Forms:

Private Sub Form_Load()
   Me.DatasheetFontHeight = 8
End Sub

There are a number of other things, for Datasheet View Forms, that can only be done using the aforementioned Properties. Michael Kaplan’s “You Can Do That with Datasheets” delineates them here:

[url]http://msdn.microsoft.com/en-us/library/office/aa217449%28v=office.11%29.aspx[/URL]

Linq ;0)>

 

[isladogs]

I believe this kind of thing, for a given Form, in Datasheet View, can only be done thru Properties that are exclusive to Datasheet View Forms:

Private Sub Form_Load()
   Me.DatasheetFontHeight = 8
End Sub

Linq ;0)>

Whilst it can certainly be done using VBA, Arnelgp is perfectly correct that it can also be done from the ribbon. Changes to font size in one datasheet have no effect on other datasheets

Thanks for posting the link to Michael Kaplan's article - very useful for remembering things easily forgotten in the mists of time

 

[missinglinq]

Not in v2007, which I run! You can change it on the ribbon, in Design View, but if you run it in Datasheet View it doesn't reflect this change.

For further reference...can anyone verify in what version doing this on the ribbon became possible?

Linq ;0)>

 

[Pat Hartman]

Forms in DS view march to the beat of their own drummer and have several unfortunate quirks. Another is that depending on the version of Access you are using, there is no way to set the column widths and get your changes to stick unless you are willing to write code that executes when the form loads. Thanks MS.

I tried to set the default using the File/Options/Datasheet but that doesn't seem to work either although if it did, it would apply to all datasheets.

 

[isladogs]

Not in v2007, which I run! You can change it on the ribbon, in Design View, but if you run it in Datasheet View it doesn't reflect this change.

For further reference...can anyone verify in what version doing this on the ribbon became possible?

Linq ;0)>

I did this in 2010 but I made the change in datasheet view using the font tools in the Home tab.
As I said this only affects the selected datasheet

For info, I've also just tested & it also works in 2007 as described above.
I suspect it was also available in 2003 and before but haven't tested it.