Making the field autosizeable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report: Invoice where I'm able to print all products my customer
buys but sometimes these products have very large descriptions. Is there any
way to get an autosizeable field so if my product needs 2 rows (but on the
same field) may move my following item and may not affect my report?

EX: QTY DESCRIP UNIT COST
1 Switch 24 ports 3Com XXXX 120.00
2 Switch 16 ports 3Com XXXX 80.00
including installation and
XXXXXX
3 Switch 8 ports 3Com 60.00
 
Paulina

Check Access HELP on the topic of CanGrow & CanShrink. These properties of
the textbox control will handle the automatic resizing, as needed.

Caution! If you have a control located directly to the right of the
CanGrow/CanShrink control, your report may seem to misbehave. Try jogging
one or the other up or down a bit until it works correctly.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks Jeff.
But what happens if the field is a combo box that brings me info from a
related table? I mean, this info comes from the products table that also
refers to the categories table. In fact, I'm using the Northwind database
that is offered as an example.
 
Paulina

If we're talking about a report, a combo box is not an appropriate
control -- the report is for printing something out, not selecting a value.

I'm confused!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top