size control datasheet view

Mark R

unread,

Aug 15, 2004, 9:27:29 AM8/15/04

to

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.

fredg

unread,

Aug 15, 2004, 10:52:13 AM8/15/04

to

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.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Mark r

unread,

Aug 15, 2004, 12:20:29 PM8/15/04

to

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

Please repost for more expert help

>
>--
>Fred
>Please only reply to this newsgroup.
>I do not reply to personal email.

>.
>

John Spencer (MVP)

unread,

Aug 15, 2004, 2:13:32 PM8/15/04

to

Pardon me. Modify the first instruction slightly.

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

Alphonse Giambrone

unread,

Aug 15, 2004, 3:22:52 PM8/15/04

to

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

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us

"Mark r" <anon...@discussions.microsoft.com> wrote in message
news:687101c482e3$c79d5320$a401...@phx.gbl...

fredg

unread,

Aug 15, 2004, 4:22:32 PM8/15/04

to

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