Link to home
Start Free TrialLog in
Avatar of Ian Leason
Ian LeasonFlag for United Kingdom of Great Britain and Northern Ireland

asked on

How to position a line at the bottom of each field on a report

Hi there,

I want to have a line at the the bottom of each field in my report - there are a number of fields in my detail section that have the can grow/can shrink set. I basically want to position a line after each field so it makes the data look better. I have attached a example of how I want this to look.

I assume I have to calculate the position of the bottom of the text field and place the line just below there - but I have not got a clue how to do this.

Alternatively I would like to enclose the field in a box so each  field has a box around the outside. Thanx in advance for any help with this.
Field-1.pdf
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

< assume I have to calculate the position of the bottom of the text field>
Not really,
Just draw a line below the last control...
<Alternatively I would like to enclose the field in a box so each  field has a box around the outside. Thanx in advance for any help with this. >

In design view of the report:
Set the "Bordestyle" of each control to: Normal
Set the "Border Width" of each control to: 1 pt
Set the "Border Color" to whatever color you want
See the report named "YourReport"
User generated imageDatabase38.mdb
...actually , I think YourReport2 here is more what you were looking for...
User generated imageDatabase38.mdb
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ian Leason

ASKER

Thank you so much - I cannot believe I didn't realise the line would automatically adjust when placed just below the field lol

The point about placing the box round the field was a little more complex as it would have had to also go round the field title :)

Thanx again :)