footer and page footer) can have independent heights. You can click on View >Rulers. Each section of the form (page header, form header, detail, form
I've also repeatedly adjusted downwards the sizes of various text boxes
in order to reduce the amount of space used, and this is reflected by the
extra unused space clearly available in Page Preview mode.
Hope that, come morning, you'll have resolved my problem!!!
For what I'm doing, incidentally, yes I DO need to use forms, since
the primary purpose is for data input by a work colleague - but then
each form does need to be printed off for our students.
Tom Wickerath said:Hi Claruspaw,
Do you have the rulers displayed in form design view? If not, click on Viewfooter and page footer) can have independent heights. You can click on View >Rulers. Each section of the form (page header, form header, detail, form
Properties to display the properties dialog. Select the Format tab of the
properties dialog. As you click into each section of the form, you should see
a height property. Add all of the height measurements together. Add the
form's top and bottom margin settings to this sum. What value do you get? In
which section is your page break placed? What is it's height setting
relative to the top of the form? Is there any chance that when you added the
page break, that you might have added a second page break at some other time,
and that it is hidden at one of the section boundries? You can use the
"lasso" technique with the left mouse button held down, to lasso various
regions of the form. Try to avoid including any visible controls when you use
this technique. When you release your left mouse button, do you see
"PageBreak" indicated in the title bar of the properties dialog in any
location other than where your known page break is placed?
The sections of the form share a common width. Click the small square in
form design view where the two rulers meet. You should see the name of the
form appear in the title bar of the properties dialog. The width of the form
should be available on the format tab. Add the form's left and right margin
settings to this value. What total width do you get?
What orientation is your default print mode set at (it is likely portrait)?
Are you using 8 1/2" x 11" sized paper? If not, what size are you using?
I've also repeatedly adjusted downwards the sizes of various text boxes
in order to reduce the amount of space used, and this is reflected by the
extra unused space clearly available in Page Preview mode.
Do you have any extra unused space shown in form design view, for each of
the form sections? If so, reduce the height of these sections accordingly.
Hope that, come morning, you'll have resolved my problem!!!
For what I'm doing, incidentally, yes I DO need to use forms, since
the primary purpose is for data input by a work colleague - but then
each form does need to be printed off for our students.
It is very easy to design a report that prints only *one* record at a time.
You can include a print button on the data entry form, so that when you or
your colleague clicks on it, a report is printed which includes only that
record (not all records available in the form's current recordset). There are
two methods that you can use to accomplish this:
1.) Using some very minor VBA code, and including the optional
WhereCondition in a DoCmd.OpenReport statement.
2.) Basing a report on a query, which looks to the open data entry form for
the primary key value as a criteria. This query would return only one record,
since it is filtered on the primary key.
Let me know the answers to the many questions I have left for you. We'll see
if we can't get this fixed for you.
Tom
________________________________________
:
Thanks, Tom. I've had a lengthy mess around with margins and with printer
settings in order to maximise print area, and have also transferred the page
header contents to the detail area, but still no joy. I've also repeatedly
adjusted downwards the sizes of various text boxes in order to reduce the
amount of space used, and this is reflected by the extra unused space clearly
available in Page Preview mode. I'm convinced that I've simply done something
daft which should be obvious - but after several hours' frustration, and now
well past midnight, I'm going to knock off for now. Hope that, come morning,
you'll have resolved my problem!!!
For what I'm doing, incidentally, yes I DO need to use forms, since the
primary purpose is for data input by a work colleague - but then each form
does need to be printed off for our students.
Sorry to have posted this question twice - first time I've used a Discussion
Group, and my first posting "disappeared" initially, so I didn't realise it
had actually happened!
claruspaw
________________________________________
:
Hi Claruspaw,
It sounds like the dimensions of your form are either too tall, or too wide,
when added with margins, to fit the dimensions of a sheet of paper for your
default print mode (landscape or portrait).
Are you really trying to print forms? Forms are used for inputting and
viewing information on a monitor. Reports should be used for printing.
Printing forms is a good way to chew up a bunch of ink, since any form
background color (likely a default grey) will be printed as well.
Tom
________________________________________
:
It seems that no matter where I put my page breaks on a [2-page] form,
covering 181 separate records, although the second page does start at the
correct point, I can't get rid of the blank pages which alternate with every
printed page.
Tom Wickerath said:Hi Claruspaw,
I'm glad to hear that you have solved this problem!
Please consider signing back in, and clicking Yes on the "Was this post
helpful to you", for one reply from myself and from Joseph Meehan.
As far as I know, the only way to print a single record from form view is to
click on File > Print... and then use the Selected Record(s) option button.
It is very easy to forget to choose this last option. I can send you a sample
database, if you are interested, which shows how to print a one-record report
by simply clicking a command button on a form.
Also, just in case you posted your *real* e-mail address in the last couple
of replies, my advice is to never do this, unless you really like receiving
loads of spam.
Tom
____________________________________
:
I cannot believe what a meal I've made of this - but we've finally cracked
it!!! Very many thanks to Tom and Joseph for all your help.
The problem did turn out to be related to form width, and although I'd
repeatedly done the mathematical bit in both directions, what hadn't really
registered was the fact that "Page Setup" gives margin widths in mm, while
the various Form Properties quote dimensions in cm. When tiredness dictates
that, while the conversion factor is actually only 10, a decimal point in the
wrong place gave the impression last night that all was well. In fact, this
morning, it was clear that my calculated page width was 215.29mm!!! By
reducing my left and right margins to something ridiculously small instantly
resolved the situation, so that I could progressively increase them to
something realistic. [Top and bottom margins still had plenty of leeway.]
Just going through your questions, Tom ...
Rulers: I always keep both rulers displayed when working in Forms because I
find that environment otherwise very user-unfriendly, and can't intuitively
visualise the relative locations of controls on a printed page.
Page Breaks: Duplicated Page Breaks [particularly those that become hidden
at top and bottom of sections] have proved a major frustration in the past.
Despite that, your reminder was useful, because I hadn't thought to check it
out this time - plus I'd not used the "lasso" technique previously, but shall
do so in the future.
Printing: I'm not yet comfortable with VBA code - one of my targets for the
future! - but I have managed to incorporate a "Print Current Record" button
into the form, which works OK. [That I'd initially inserted a "Print Current
FORM" command in error almost sparked off a further series of HELLPPPPP!!!!!
questions, till I noticed that 300+ pages were spooling to the printer ...!]
As far as wasting ink on coloured backgrounds is concerned - I always use a
transparent background anyway, so that doesn't constitute a problem.
Very grateful for your help, and delighted to have discovered this
Discussion Group.
Cheers,
claruspaw
Tom Wickerath said:Hi Claruspaw,
I'm glad to hear that you have solved this problem!
Please consider signing back in, and clicking Yes on the "Was this post
helpful to you", for one reply from myself and from Joseph Meehan.
As far as I know, the only way to print a single record from form view is to
click on File > Print... and then use the Selected Record(s) option button.
It is very easy to forget to choose this last option. I can send you a sample
database, if you are interested, which shows how to print a one-record report
by simply clicking a command button on a form.
Also, just in case you posted your *real* e-mail address in the last couple
of replies, my advice is to never do this, unless you really like receiving
loads of spam.
Tom
____________________________________
:
I cannot believe what a meal I've made of this - but we've finally cracked
it!!! Very many thanks to Tom and Joseph for all your help.
The problem did turn out to be related to form width, and although I'd
repeatedly done the mathematical bit in both directions, what hadn't really
registered was the fact that "Page Setup" gives margin widths in mm, while
the various Form Properties quote dimensions in cm. When tiredness dictates
that, while the conversion factor is actually only 10, a decimal point in the
wrong place gave the impression last night that all was well. In fact, this
morning, it was clear that my calculated page width was 215.29mm!!! By
reducing my left and right margins to something ridiculously small instantly
resolved the situation, so that I could progressively increase them to
something realistic. [Top and bottom margins still had plenty of leeway.]
Just going through your questions, Tom ...
Rulers: I always keep both rulers displayed when working in Forms because I
find that environment otherwise very user-unfriendly, and can't intuitively
visualise the relative locations of controls on a printed page.
Page Breaks: Duplicated Page Breaks [particularly those that become hidden
at top and bottom of sections] have proved a major frustration in the past.
Despite that, your reminder was useful, because I hadn't thought to check it
out this time - plus I'd not used the "lasso" technique previously, but shall
do so in the future.
Printing: I'm not yet comfortable with VBA code - one of my targets for the
future! - but I have managed to incorporate a "Print Current Record" button
into the form, which works OK. [That I'd initially inserted a "Print Current
FORM" command in error almost sparked off a further series of HELLPPPPP!!!!!
questions, till I noticed that 300+ pages were spooling to the printer ...!]
As far as wasting ink on coloured backgrounds is concerned - I always use a
transparent background anyway, so that doesn't constitute a problem.
Very grateful for your help, and delighted to have discovered this
Discussion Group.
Cheers,
claruspaw
which was what I was looking for, and that I really would like to respond
to in the affirmative.
[email protected] said:Hi, Tom!
Realised after the event that I'd not clicked on the "Did this post answer
the question?" button, so have now done so. However, I still can't find the
"Was this post helpful to you?" route, which was what I was looking for, and
that I really would like to respond to in the affirmative. Give me a clue,
and I'll happily confirm.
For the "Print Current Record" option, I used the Command Button Wizard,
selecting "Record Operations" [NOT "Form Operations"], then "Print Record".
Appreciate the advice re Email addresses. Hadn't realised that it was
possible to use a "dummy", but will investigate. [That being said, I do have
an excellent spam filter.]
Just as an aside, I've recently discovered "GMail" [a web-based email
account set up by Google, which is really excellent, and can only be opened
by direct invitation]. If you might be interested in having a GMail account,
then send me a direct email, and I'll send you an invitation today.
Cheers,
claruspaw
Tom Wickerath said:Hi Claruspaw,
I'm glad to hear that you have solved this problem!
Please consider signing back in, and clicking Yes on the "Was this post
helpful to you", for one reply from myself and from Joseph Meehan.
As far as I know, the only way to print a single record from form view is to
click on File > Print... and then use the Selected Record(s) option button.
It is very easy to forget to choose this last option. I can send you a sample
database, if you are interested, which shows how to print a one-record report
by simply clicking a command button on a form.
Also, just in case you posted your *real* e-mail address in the last couple
of replies, my advice is to never do this, unless you really like receiving
loads of spam.
Tom
____________________________________
:
I cannot believe what a meal I've made of this - but we've finally cracked
it!!! Very many thanks to Tom and Joseph for all your help.
The problem did turn out to be related to form width, and although I'd
repeatedly done the mathematical bit in both directions, what hadn't really
registered was the fact that "Page Setup" gives margin widths in mm, while
the various Form Properties quote dimensions in cm. When tiredness dictates
that, while the conversion factor is actually only 10, a decimal point in the
wrong place gave the impression last night that all was well. In fact, this
morning, it was clear that my calculated page width was 215.29mm!!! By
reducing my left and right margins to something ridiculously small instantly
resolved the situation, so that I could progressively increase them to
something realistic. [Top and bottom margins still had plenty of leeway.]
Just going through your questions, Tom ...
Rulers: I always keep both rulers displayed when working in Forms because I
find that environment otherwise very user-unfriendly, and can't intuitively
visualise the relative locations of controls on a printed page.
Page Breaks: Duplicated Page Breaks [particularly those that become hidden
at top and bottom of sections] have proved a major frustration in the past.
Despite that, your reminder was useful, because I hadn't thought to check it
out this time - plus I'd not used the "lasso" technique previously, but shall
do so in the future.
Printing: I'm not yet comfortable with VBA code - one of my targets for the
future! - but I have managed to incorporate a "Print Current Record" button
into the form, which works OK. [That I'd initially inserted a "Print Current
FORM" command in error almost sparked off a further series of HELLPPPPP!!!!!
questions, till I noticed that 300+ pages were spooling to the printer ...!]
As far as wasting ink on coloured backgrounds is concerned - I always use a
transparent background anyway, so that doesn't constitute a problem.
Very grateful for your help, and delighted to have discovered this
Discussion Group.
Cheers,
claruspaw
Tom Wickerath said:However, I still can't find the "Was this post helpful to you?" route,
which was what I was looking for, and that I really would like to respond
to in the affirmative.
Apparently, as the original poster (OP), you see a button marked "Did this
post answer the question?" instead of a button marked "Was this post helpful
to you?" I have never initiated a question myself, using the web portal, so
I was unaware of this difference. By marking our responses as answers, you
did exactly as I was asking.
Thank You,
Tom
__________________________________
[email protected] said:Hi, Tom!
Realised after the event that I'd not clicked on the "Did this post answer
the question?" button, so have now done so. However, I still can't find the
"Was this post helpful to you?" route, which was what I was looking for, and
that I really would like to respond to in the affirmative. Give me a clue,
and I'll happily confirm.
For the "Print Current Record" option, I used the Command Button Wizard,
selecting "Record Operations" [NOT "Form Operations"], then "Print Record".
Appreciate the advice re Email addresses. Hadn't realised that it was
possible to use a "dummy", but will investigate. [That being said, I do have
an excellent spam filter.]
Just as an aside, I've recently discovered "GMail" [a web-based email
account set up by Google, which is really excellent, and can only be opened
by direct invitation]. If you might be interested in having a GMail account,
then send me a direct email, and I'll send you an invitation today.
Cheers,
claruspaw
Tom Wickerath said:Hi Claruspaw,
I'm glad to hear that you have solved this problem!
Please consider signing back in, and clicking Yes on the "Was this post
helpful to you", for one reply from myself and from Joseph Meehan.
As far as I know, the only way to print a single record from form view is to
click on File > Print... and then use the Selected Record(s) option button.
It is very easy to forget to choose this last option. I can send you a sample
database, if you are interested, which shows how to print a one-record report
by simply clicking a command button on a form.
Also, just in case you posted your *real* e-mail address in the last couple
of replies, my advice is to never do this, unless you really like receiving
loads of spam.
Tom
____________________________________
:
I cannot believe what a meal I've made of this - but we've finally cracked
it!!! Very many thanks to Tom and Joseph for all your help.
The problem did turn out to be related to form width, and although I'd
repeatedly done the mathematical bit in both directions, what hadn't really
registered was the fact that "Page Setup" gives margin widths in mm, while
the various Form Properties quote dimensions in cm. When tiredness dictates
that, while the conversion factor is actually only 10, a decimal point in the
wrong place gave the impression last night that all was well. In fact, this
morning, it was clear that my calculated page width was 215.29mm!!! By
reducing my left and right margins to something ridiculously small instantly
resolved the situation, so that I could progressively increase them to
something realistic. [Top and bottom margins still had plenty of leeway.]
Just going through your questions, Tom ...
Rulers: I always keep both rulers displayed when working in Forms because I
find that environment otherwise very user-unfriendly, and can't intuitively
visualise the relative locations of controls on a printed page.
Page Breaks: Duplicated Page Breaks [particularly those that become hidden
at top and bottom of sections] have proved a major frustration in the past.
Despite that, your reminder was useful, because I hadn't thought to check it
out this time - plus I'd not used the "lasso" technique previously, but shall
do so in the future.
Printing: I'm not yet comfortable with VBA code - one of my targets for the
future! - but I have managed to incorporate a "Print Current Record" button
into the form, which works OK. [That I'd initially inserted a "Print Current
FORM" command in error almost sparked off a further series of HELLPPPPP!!!!!
questions, till I noticed that 300+ pages were spooling to the printer ...!]
As far as wasting ink on coloured backgrounds is concerned - I always use a
transparent background anyway, so that doesn't constitute a problem.
Very grateful for your help, and delighted to have discovered this
Discussion Group.
Cheers,
claruspaw
Joseph Meehan said:I cannot believe what a meal I've made of this - but we've finally
cracked it!!! Very many thanks to Tom and Joseph for all your help.
The problem did turn out to be related to form width, and although I'd
repeatedly done the mathematical bit in both directions, what hadn't
really registered was the fact that "Page Setup" gives margin widths
in mm, while the various Form Properties quote dimensions in cm. When
tiredness dictates that, while the conversion factor is actually only
10, a decimal point in the wrong place gave the impression last night
that all was well. In fact, this morning, it was clear that my
calculated page width was 215.29mm!!! By reducing my left and right
margins to something ridiculously small instantly resolved the
situation, so that I could progressively increase them to something
realistic. [Top and bottom margins still had plenty of leeway.]
Just going through your questions, Tom ...
Rulers: I always keep both rulers displayed when working in Forms
because I find that environment otherwise very user-unfriendly, and
can't intuitively visualise the relative locations of controls on a
printed page.
Page Breaks: Duplicated Page Breaks [particularly those that become
hidden at top and bottom of sections] have proved a major frustration
in the past. Despite that, your reminder was useful, because I hadn't
thought to check it out this time - plus I'd not used the "lasso"
technique previously, but shall do so in the future.
Printing: I'm not yet comfortable with VBA code - one of my targets
for the future! - but I have managed to incorporate a "Print Current
Record" button into the form, which works OK. [That I'd initially
inserted a "Print Current FORM" command in error almost sparked off a
further series of HELLPPPPP!!!!! questions, till I noticed that 300+
pages were spooling to the printer ...!] As far as wasting ink on
coloured backgrounds is concerned - I always use a transparent
background anyway, so that doesn't constitute a problem.
Very grateful for your help, and delighted to have discovered this
Discussion Group.
Thank you for returning to let us know it worked. That always makes us
feel like we are getting somewhere.
Cheers,
claruspaw
Tom Wickerath said:Hi Claruspaw,
Do you have the rulers displayed in form design view? If not, click
on View
Rulers. Each section of the form (page header, form header, detail,
form
footer and page footer) can have independent heights. You can click
on View > Properties to display the properties dialog. Select the
Format tab of the properties dialog. As you click into each section
of the form, you should see a height property. Add all of the height
measurements together. Add the form's top and bottom margin settings
to this sum. What value do you get? In which section is your page
break placed? What is it's height setting relative to the top of
the form? Is there any chance that when you added the page break,
that you might have added a second page break at some other time,
and that it is hidden at one of the section boundries? You can use
the "lasso" technique with the left mouse button held down, to lasso
various regions of the form. Try to avoid including any visible
controls when you use this technique. When you release your left
mouse button, do you see "PageBreak" indicated in the title bar of
the properties dialog in any location other than where your known
page break is placed?
The sections of the form share a common width. Click the small
square in form design view where the two rulers meet. You should see
the name of the form appear in the title bar of the properties
dialog. The width of the form should be available on the format tab.
Add the form's left and right margin settings to this value. What
total width do you get?
What orientation is your default print mode set at (it is likely
portrait)? Are you using 8 1/2" x 11" sized paper? If not, what
size are you using?
I've also repeatedly adjusted downwards the sizes of various text
boxes in order to reduce the amount of space used, and this is
reflected by the extra unused space clearly available in Page
Preview mode.
Do you have any extra unused space shown in form design view, for
each of the form sections? If so, reduce the height of these
sections accordingly.
Hope that, come morning, you'll have resolved my problem!!!
I may be good, but I'm no magician! <smile>
For what I'm doing, incidentally, yes I DO need to use forms, since
the primary purpose is for data input by a work colleague - but then
each form does need to be printed off for our students.
It is very easy to design a report that prints only *one* record at
a time. You can include a print button on the data entry form, so
that when you or your colleague clicks on it, a report is printed
which includes only that record (not all records available in the
form's current recordset). There are two methods that you can use to
accomplish this:
1.) Using some very minor VBA code, and including the optional
WhereCondition in a DoCmd.OpenReport statement.
2.) Basing a report on a query, which looks to the open data entry
form for the primary key value as a criteria. This query would
return only one record, since it is filtered on the primary key.
Let me know the answers to the many questions I have left for you.
We'll see if we can't get this fixed for you.
Tom
________________________________________
:
Thanks, Tom. I've had a lengthy mess around with margins and with
printer settings in order to maximise print area, and have also
transferred the page header contents to the detail area, but still
no joy. I've also repeatedly adjusted downwards the sizes of various
text boxes in order to reduce the amount of space used, and this is
reflected by the extra unused space clearly available in Page
Preview mode. I'm convinced that I've simply done something daft
which should be obvious - but after several hours' frustration, and
now well past midnight, I'm going to knock off for now. Hope that,
come morning, you'll have resolved my problem!!!
For what I'm doing, incidentally, yes I DO need to use forms, since
the primary purpose is for data input by a work colleague - but then
each form does need to be printed off for our students.
Sorry to have posted this question twice - first time I've used a
Discussion Group, and my first posting "disappeared" initially, so I
didn't realise it had actually happened!
claruspaw
________________________________________
:
Hi Claruspaw,
It sounds like the dimensions of your form are either too tall, or
too wide, when added with margins, to fit the dimensions of a sheet
of paper for your default print mode (landscape or portrait).
Are you really trying to print forms? Forms are used for inputting
and viewing information on a monitor. Reports should be used for
printing. Printing forms is a good way to chew up a bunch of ink,
since any form background color (likely a default grey) will be
printed as well.
Tom
________________________________________
:
It seems that no matter where I put my page breaks on a [2-page]
form, covering 181 separate records, although the second page does
start at the correct point, I can't get rid of the blank pages which
alternate with every printed page.