Can Grow in Report Still Not Showing All Data

[Larry R Harrison Jr]

I have Access 97, and I have a report with a text box which has the "Can
Grow" set to yes. Regardless, it still doesn't show all the data of the tet
box.

It does grow vertically, but the data still looks like this:

Rather than

Now is the time for
all good men to come
to the aid of their
country

It looks more like

Now is th
all good m
to the aid o
country

Tips?

LRH

[Allen Browne]

Re: Can Grow in Report Still Not Showing All Data

There is a problem with the font metrics.
That could be the fault of the font, or of the printer driver.

Try a standard font (e.g. Arial or Times New Roman).
If that does not solve the problem, try a different printer driver.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Larry R Harrison Jr" <private@email. net> wrote in message
news:kEETb.2851 3$P17.16119@fed 1read03...[color=blue]
> I have Access 97, and I have a report with a text box which has the "Can
> Grow" set to yes. Regardless, it still doesn't show all the data of the[/color]
tet[color=blue]
> box.
>
> It does grow vertically, but the data still looks like this:
>
> Rather than
>
> Now is the time for
> all good men to come
> to the aid of their
> country
>
> It looks more like
>
> Now is th
> all good m
> to the aid o
> country
>
> Tips?
>
> LRH[/color]

[Larry R Harrison Jr]

Re: Can Grow in Report Still Not Showing All Data

It shows that way on the SCREEN too.


"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message
news:401f1b9f$0 $1753$5a62ac22@ freenews.iinet. net.au...[color=blue]
> There is a problem with the font metrics.
> That could be the fault of the font, or of the printer driver.
>
> Try a standard font (e.g. Arial or Times New Roman).
> If that does not solve the problem, try a different printer driver.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Larry R Harrison Jr" <private@email. net> wrote in message
> news:kEETb.2851 3$P17.16119@fed 1read03...[color=green]
> > I have Access 97, and I have a report with a text box which has the "Can
> > Grow" set to yes. Regardless, it still doesn't show all the data of the[/color]
> tet[color=green]
> > box.
> >
> > It does grow vertically, but the data still looks like this:
> >
> > Rather than
> >
> > Now is the time for
> > all good men to come
> > to the aid of their
> > country
> >
> > It looks more like
> >
> > Now is th
> > all good m
> > to the aid o
> > country
> >
> > Tips?
> >
> > LRH[/color]
>
>[/color]

[Allen Browne]

Re: Can Grow in Report Still Not Showing All Data

Yes, Larry. Access uses the printer metrics to calculate how the report will
print and show a preview. That's why report can't preview properly on a
computer that has no printers installed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Larry R Harrison Jr" <private@email. net> wrote in message
news:w7FTb.2853 1$P17.22572@fed 1read03...[color=blue]
> It shows that way on the SCREEN too.[/color]

[Larry R Harrison Jr]

Re: Can Grow in Report Still Not Showing All Data

Actually I think I do have a printer driver installed on that machine, if I
remember correctly.


"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message
news:401f2586$0 $1727$5a62ac22@ freenews.iinet. net.au...[color=blue]
> Yes, Larry. Access uses the printer metrics to calculate how the report[/color]
will[color=blue]
> print and show a preview. That's why report can't preview properly on a
> computer that has no printers installed.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Larry R Harrison Jr" <private@email. net> wrote in message
> news:w7FTb.2853 1$P17.22572@fed 1read03...[color=green]
> > It shows that way on the SCREEN too.[/color]
>
>[/color]

[Bas Cost Budde]

Re: Can Grow in Report Still Not Showing All Data

Larry R Harrison Jr wrote:
[color=blue]
> I have Access 97, and I have a report with a text box which has the "Can
> Grow" set to yes. Regardless, it still doesn't show all the data of the tet
> box.
>
> It does grow vertically, but the data still looks like this:[/color]

CanGrow only affects vertical size. If you want your control to grow
*horizontally* you have homework. I feel that has to be done from code,
but I have no pointers for you about font size etc.

Does the text not flow?

--
Bas Cost Budde

http://www.heuveltop.nl/BasCB

[Larry R Harrison Jr]

Re: Can Grow in Report Still Not Showing All Data

That is right it does not flow

rather than saying

now is the time
forall good men to
come to the aid
of their country

(Growing vertically)

it looks like

now is the ti
for all good m
come to the a
of their coun

LRH


"Bas Cost Budde" <bas@heuveltop. org> wrote in message
news:bvnp7j$od5 $4@news2.solcon .nl...[color=blue]
> Larry R Harrison Jr wrote:
>[color=green]
> > I have Access 97, and I have a report with a text box which has the "Can
> > Grow" set to yes. Regardless, it still doesn't show all the data of the[/color][/color]
tet[color=blue][color=green]
> > box.
> >
> > It does grow vertically, but the data still looks like this:[/color]
>
> CanGrow only affects vertical size. If you want your control to grow
> *horizontally* you have homework. I feel that has to be done from code,
> but I have no pointers for you about font size etc.
>
> Does the text not flow?
>
> --
> Bas Cost Budde
> http://www.heuveltop.nl/BasCB
>[/color]