Simulate box

  • Thread starter Thread starter Renee Moffett
  • Start date Start date
R

Renee Moffett

I'm trying to produce an access report similar in format to a manually
generated document given to me as an example. Part of the data in the
example is surrounded by a box. The vertical lines are no problem. But the
vertical lines in my header should grow/shrink with the data. How can I
capture the width of the section and apply it to the lines? Is there a
better solution than this? Thanks everyone.

Renee
 
Renee Moffett said:
I'm trying to produce an access report similar in format to a manually
generated document given to me as an example. Part of the data in the
example is surrounded by a box. The vertical lines are no problem. But the
vertical lines in my header should grow/shrink with the data. How can I
capture the width of the section and apply it to the lines? Is there a
better solution than this?
Click to expand...

The Width of the section is the Width of the report, i.e.
Me.Width

But that doesn't make sense to me, the lines need to
grow/shrink vertically not horizontally. If that's what you
really meant to say, then the way to do it is to use the
section's Print event to draw the lines using the report's
Line method (see Help for details). If you're drawing the
lines to the section'sbottom, then you do not need to know
the Height of the section since the Line method is clipped
at the section boundaries.
 
Sorry, Marshall. I wasn't firing on all cylinders when I posted this. I
meant the height of the section. But, it turns out that isn't an issue,
since I made my line the height of the detail section and the line
'lengthened' for each record. So, the initial reason for my post is solved.

But of course, I have more questions. The report I'm trying to duplicate
has data similar to what follows.

Summary Data | Detail Data
______________
| Detail Data
____________ _________________
Summary Data | Detail Data
____________ _________________
Summary Data | Detail Data


The first 2 detail records in my example have the same summary data. I have
repeat property set to 'no' so the summary data doesn't appear twice. But I
want the first left horizontal line to not appear between the first and
second records. How can I do this?

Thanks very much.

Renee
 
Renee Moffett said:
Sorry, Marshall. I wasn't firing on all cylinders when I posted this. I
meant the height of the section. But, it turns out that isn't an issue,
since I made my line the height of the detail section and the line
'lengthened' for each record. So, the initial reason for my post is solved.
Click to expand...

That must be a new feature, I'll have to check it out. What
version are you using?

But of course, I have more questions. The report I'm trying to duplicate
has data similar to what follows.

Summary Data | Detail Data
______________
| Detail Data
____________ _________________
Summary Data | Detail Data
____________ _________________
Summary Data | Detail Data


The first 2 detail records in my example have the same summary data. I have
repeat property set to 'no' so the summary data doesn't appear twice. But I
want the first left horizontal line to not appear between the first and
second records.
Click to expand...

OK. That I can understand ;-) Well, maybe not. There is
no "Repeat" property, so I'll guess that you meant to say
the HideDuplicates property is set to Yes.

Assuming the summary data is a text box named Summary. Add
two line controls positioned at the top of the detail
section. Name one of them linLong and make it the full
width. Name the other one linShort and make it's left start
over the detail data controls. Then add code to the detail
section's Format event:

Me.linLong.Visible = Me.Summary.IsVisible
Me.linShort.Visible = Not Me.Summary.IsVisible
--
Marsh
MVP [MS Access]


 
Back
Top