size control datasheet view

M

Mark R

Is there a way to shrink the font size and grid size of a
DATASHEET subreport/subform inside of a report?

Usually I set font size in properties of a label or text
box, but I find that with a DATASHEET, the grid stays the
same size whether I collapse the size of the report or
even if I adjust property settings for every control item
in the subreport/form. Most of my controls are font 7 or
8 in my report, but the datasheet comes out a standard
size, perhaps 10 or 12 ?

Please be very specific in your instructions, as I have
played with the properties alot and gotten no where and
the obvious is not obvious to me.
 
F

fredg

Is there a way to shrink the font size and grid size of a
DATASHEET subreport/subform inside of a report?

Usually I set font size in properties of a label or text
box, but I find that with a DATASHEET, the grid stays the
same size whether I collapse the size of the report or
even if I adjust property settings for every control item
in the subreport/form. Most of my controls are font 7 or
8 in my report, but the datasheet comes out a standard
size, perhaps 10 or 12 ?

Please be very specific in your instructions, as I have
played with the properties alot and gotten no where and
the obvious is not obvious to me.
Click to expand...

Open the form.
Select any cell in the sub-form.
Click on Format + Fonts
Select the Font Size.
While there you can also set the column width and row height.
(You can also simply drag the column Header's right edge wider or
narrower at any time. Or just double click the edge to have it adjust
to fit.)
Save the changes.
 
M

Mark r

Fred, I appreciate your attempt, but it doesn't seem to
work that way.

In my report, I have a subform. In print preview, you
cannot click on a cell, you just get a magnifying glass.
Open the form.
Select any cell in the sub-form.
Click on Format + Fonts
Select the Font Size.
While there you can also set the column width and row
Click to expand...
height.

If you click on an adge and drag, you just cutout the
display of DATASHEET columns.
(You can also simply drag the column Header's right edge wider or
narrower at any time. Or just double click the edge to have it adjust
to fit.)
Save the changes.
Click to expand...

Please repost for more expert help
 
J

John Spencer (MVP)

Pardon me. Modify the first instruction slightly.

Open the Form/Report or the SubForm/SubReport in DESIGN VIEW
 
A

Alphonse Giambrone

You don't specify what version of Access you are using, but assuming these
properties have not changed for the latest version.

If you use a normal report for the subreport, you can set the font
properties in the manner that you are used to.

If you are actually using a form datasheet, Fred's method will work. Just
open the form by itself, in datasheet view, outside of the report.

If you can't do that for some reason, you can set the properties via code in
the open event.
Me.DataSheetFontName="Arial"
Me.DataSheetFontHeight = 8

Look in help for the names of the other datasheet font properties.

HTH
 
F

fredg

Fred, I appreciate your attempt, but it doesn't seem to
work that way.

In my report, I have a subform. In print preview, you
cannot click on a cell, you just get a magnifying glass.

height.

If you click on an adge and drag, you just cutout the
display of DATASHEET columns.


Please repost for more expert help
Click to expand...

Sorry, I misread your post. I overlooked the word Report, and gave you
the instructions to change the font size in a Form datasheet.
 
Top