Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2012-09-04
6
Medium Priority
?
495 Views
Last Modified: 2012-09-04
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
0
Comment
Question by:Ian Leason
  • 5
6 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38365041
< assume I have to calculate the position of the bottom of the text field>
Not really,
Just draw a line below the last control...
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38365063
<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
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38365097
See the report named "YourReport"
imageDatabase38.mdb
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38365121
...actually , I think YourReport2 here is more what you were looking for...
imageDatabase38.mdb
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 38365202
LOL

Or YourReport 3 here...
imageDatabase38.mdb
0
 

Author Closing Comment

by:Ian Leason
ID: 38366009
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 :)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question