Padding

[Steve]

Left, Right, Top and Bottom Padding all seem to default to .0208". If any or
all are set to 0", they seem to default back to .0208" Is there a way to set
these to 0" and keep it at 0" or sey them to default to 0"?

I have a report containing several subreports below a row of textboxes. When
the report prints, there is a heavy line where the subreport begins and
ends. I'm speculating that top and bottom padding of the subform control
keeps the subeport from exactly overlaying the textboxes.

Thanks,

Steve

 

[John... Visio MVP]

Left, Right, Top and Bottom Padding all seem to default to .0208". If any
or all are set to 0", they seem to default back to .0208" Is there a way
to set these to 0" and keep it at 0" or sey them to default to 0"?

I have a report containing several subreports below a row of textboxes.
When the report prints, there is a heavy line where the subreport begins
and ends. I'm speculating that top and bottom padding of the subform
control keeps the subeport from exactly overlaying the textboxes.

Thanks,

Steve

I can do that for a modest fee and I do not have to see the code. ;-)

John... Visio MVP

 

[Keith Wilby]

The first thing you need to do is start following the NG rules.

 

[BruceM]

Ordinarily I would ask about the version of Access you are using, and would
ask about other things such as what you mean by padding (margins), and to
what control or control type do you refer. In Access 2003 and earlier there
is no Margin property for a subform control, so it is hard to know where the
default value is set to .0208. Also, is the Dividing Lines property set to
Yes anywhere? Does this happen with all subreports or just one of them?
This database or all of them? What do you mean "ovrlaying the text boxes"?

As it is I have to wonder about the skill set of somebody who claims to be
able to devise "reasonable fee" solutions to situations described in a
sentence or two.

 

[Steve]

Access2007

Padding is not the same as margins!

<padding of the subform control>
My mistake; I meant subreport.

If you select the subreport control, open properties and go to the Format
tab, you will see the four padding properties. Each of these seem to default
to .0208".

This happens with all subreports. I don't know if ot happens just in this
database or if it will happen in all databases.

"ovrlaying the text boxes" means the bottom border of the subreport in the
first record of the main report sits on the top border of the textboxes in
the second record of the main report. "ovrlaying the text boxes" means the
top border of the subreport in the second record of the main report sits on
the top border of the textboxes in the first record of the main report. The
heavy line occurs where the subreport begins and ends.

Steve

 

[BruceM]

I accidentally used "subform control" and "subreport control"
interchangeably, but they are pretty much the same thing in Access 2003. I
don't see any padding properties in Access 2003, so it must be a 2007 thing
only. I don't have that version here. No guess as to why it won't accept
your input for the padding property.

Help has information in Access 2003 about changing default properties for
controls. More here: http://allenbrowne.com/ser-43.html

A Help search for Default Properties may head you in the right direction.
In Access 2003 you click a control type in the toolbox, then click the
Properties icon to set default properites for that control type. It applies
only to that database unless you use a template. I think Access 2007 is
rather different in its use of templates and of this type of thing in
general, so I will leave you to check the Help files.

Your description of overlaying seems that maybe you rewrote it but did not
remove the first attempt. I don't see how the top border of the second
record's subreport is sitting on the top border of the first record in the
main report. However, the first part makes sense. My only suggestion is to
move the controls farther apart as a test, to see if the thick line could be
two thinner lines very close together.

 

[Steve]

Correction .....

"ovrlaying the text boxes" means the top border of the subreport in the
second record of the main report sits
on the bottom border of the textboxes in the first record of the main
report.

<<In Access 2003 you click a control type in the toolbox, then click the
Properties icon to set default properites for that control type. >>
Works in Access2007! Thanks for the information.

Steve

 

[BruceM]

Glad to hear the basic mechanism is similar for defaults.

I'm still puzzled by your description, unless the subreport is above the
main record. I would have expected the bottom border of the first record's
supreport to sit on the top border of the second record's main section:

Main1
Sub1
Main2
Sub2

In any case, I would try separating the controls vertically as a test.