Subform/DatasheetView/Font Change?

  • Thread starter Thread starter Tim Fierro
  • Start date Start date
T

Tim Fierro

Hello,

I have a Subform that is set in Datasheet View. The main form is the
Purchase Order and the subform is the Order Details. I have managed to
change the fonts on the subform but it only shows the fonts in 'form' view;
I want the new fonts to take effect while in Datasheet View.

Is there a way to change the fonts in the Datasheet View?

Tim
 
Okay, Tim, while you have the form open in Datasheet view,
choose Font on the Format menu.

That seems to set the size for that particular form.
Click to expand...

Yes, that did work for changing the font for the Datasheet View.

However, I am probably not calling my view correctly. While your fix worked
for changing that view, evidently that is not what my view is called.

I have a form, and an attached subform. The subform view looks like a
datasheet view. This is the view (While the Form and Subform are in Form
View) that I want to keep but have the lower part (subform) have a different
font.

So while I 'think' the view I am looking at on the form is Datasheet view,
it is not. I realize this now since when I open the form and then manually
tell it to show Datasheet view, it changes screen; the of course changes
back to my view (Form View) when I choose that option. I obviously have a
form view then on that subform, but it looks like I want except for a font
change.

AH AH! I did it!

I loaded the subform by itself, then told it to change it's font, and now it
works exactly what I wanted.

Thank you very much Allen.

Tim
 
Well, if it's not a form in Datasheet view, it might be in Continuous view?
If so, each control has its own FontSize property.

Or perhaps it is a Subdatasheet--not really a form, just a little + sign
that you use to open out related records. Beyond what I already suggested, I
don't know what else would work for these. I always turn them off: they are
mostly unhelpful, inefficient (slowing form loads dramatically), and lacking
in events so I don't want my users to get them.
 
Back
Top