Can i stop Rectangles growing on my report header?

  • Thread starter Thread starter Douglas
  • Start date Start date
D

Douglas

Im having trouble with the design of the report header of my invoice
Its Looks like this below

Page is Landscape
_______________________________________
| | Cust Name |
| Company Name | Cust Addr | Report Header
| Company Address | Car Details |
| Company Tel No | Mileage |
|_________________________|_____________|

The problem is that because Cust Addr is a multiline text field it can
be various sizes in height (Can Grow = Yes) which causes the rectangle
i have drawn around the Company information on the left to resize
itself according

Sometimes the box i have drawn is correct, but if the Cust Addr has
many lines in it the rectangle will grow, i cant find a Can Grow
property for the rectangle.
Campany Name, Address and Tel No are just labels.
Is there a way to stop this happening apart from using a Bitmap image?

TIA

Doug
 
Doug,

The bit I don't understand is "Campany Name, Address and Tel No are just
labels". I don't think labels can have a CanGrow property! Surely they
must be in bound textboxes?

If so, I can think of two possible approaches to this problem. One is
to use code on the Format event of the Report Header section, to adjust
the size of the rectangle according to the size of the address field.

The other way, which is I think what I would do, is concatenate all this
data into one field. Do this in the query that the report is based on,
e.g....
CompanyHeader: [Company Name] & Chr(13) & Chr(10) & [Company Address] &
Chr(13) & Chr(10) & [Company Tel No]
Then, replace the three existing controls on the report with just one
textbox bound to this concatenated field, set its CanGrow property to
Yes, remove the rectangle, and give the textbox a solid border.

- Steve Schapel, Microsoft Access MVP

Im having trouble with the design of the report header of my invoice
Its Looks like this below

Page is Landscape
_______________________________________
| | Cust Name |
| Company Name | Cust Addr | Report Header
| Company Address | Car Details |
| Company Tel No | Mileage |
|_________________________|_____________|

The problem is that because Cust Addr is a multiline text field it can
be various sizes in height (Can Grow = Yes) which causes the rectangle
i have drawn around the Company information on the left to resize
itself according

Sometimes the box i have drawn is correct, but if the Cust Addr has
many lines in it the rectangle will grow, i cant find a Can Grow
property for the rectangle.
Campany Name, Address and Tel No are just labels.
Is there a way to stop this happening apart from using a Bitmap image?

TIA

Doug
Click to expand...

--
 
Doug,

Sorry, I just re-read your question, and I see I have completely missed
the point. Sorry. Please disregard my earlier reply.

- Steve Schapel, Microsoft Access MVP


Steve said:
Doug,

The bit I don't understand is "Campany Name, Address and Tel No are just
labels". I don't think labels can have a CanGrow property! Surely they
must be in bound textboxes?

If so, I can think of two possible approaches to this problem. One is
to use code on the Format event of the Report Header section, to adjust
the size of the rectangle according to the size of the address field.

The other way, which is I think what I would do, is concatenate all this
data into one field. Do this in the query that the report is based on,
e.g....
CompanyHeader: [Company Name] & Chr(13) & Chr(10) & [Company Address] &
Chr(13) & Chr(10) & [Company Tel No]
Then, replace the three existing controls on the report with just one
textbox bound to this concatenated field, set its CanGrow property to
Yes, remove the rectangle, and give the textbox a solid border.

- Steve Schapel, Microsoft Access MVP

Im having trouble with the design of the report header of my invoice
Its Looks like this below

Page is Landscape
_______________________________________
| | Cust Name |
| Company Name | Cust Addr | Report Header
| Company Address | Car Details |
| Company Tel No | Mileage |
|_________________________|_____________|

The problem is that because Cust Addr is a multiline text field it can
be various sizes in height (Can Grow = Yes) which causes the rectangle
i have drawn around the Company information on the left to resize
itself according

Sometimes the box i have drawn is correct, but if the Cust Addr has
many lines in it the rectangle will grow, i cant find a Can Grow
property for the rectangle.
Campany Name, Address and Tel No are just labels.
Is there a way to stop this happening apart from using a Bitmap image?

TIA

Doug
Click to expand...
Click to expand...
 
Back
Top