By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 1,037 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

Can Grow in Report Still Not Showing All Data

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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" <pr*****@email.net> wrote in message
news:kEETb.28513$P17.16119@fed1read03...
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

Nov 12 '05 #2

P: n/a
It shows that way on the SCREEN too.
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40**********************@freenews.iinet.net.a u...
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" <pr*****@email.net> wrote in message
news:kEETb.28513$P17.16119@fed1read03...
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


Nov 12 '05 #3

P: n/a
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" <pr*****@email.net> wrote in message
news:w7FTb.28531$P17.22572@fed1read03...
It shows that way on the SCREEN too.

Nov 12 '05 #4

P: n/a
Actually I think I do have a printer driver installed on that machine, if I
remember correctly.
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:40**********************@freenews.iinet.net.a u...
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" <pr*****@email.net> wrote in message
news:w7FTb.28531$P17.22572@fed1read03...
It shows that way on the SCREEN too.


Nov 12 '05 #5

P: n/a
Larry R Harrison Jr wrote:
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:


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

Nov 12 '05 #6

P: n/a
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" <ba*@heuveltop.org> wrote in message
news:bv**********@news2.solcon.nl...
Larry R Harrison Jr wrote:
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:


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

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.