Notes field in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my report I have put in a page break, the second page is for notes. In
some records I do not have to type in any notes. Is their any way that I
can get my report just to print the second page when their is notes in this
field.
 
You can add code to the On Format event of the section that makes the page
break invisible if the notes field is null.

Me.PgBrkControl.Visible = Len([Notes] & "") >0
 
Thanks for that. I have tried it but it does not work. I have I parameter
set to search for between dates. When I put in the code the parameter asks me
for a start date & end date twice and then shows no records at all

Duane Hookom said:
You can add code to the On Format event of the section that makes the page
break invisible if the notes field is null.

Me.PgBrkControl.Visible = Len([Notes] & "") >0

--
Duane Hookom
MS Access MVP
--

horseman said:
In my report I have put in a page break, the second page is for notes. In
some records I do not have to type in any notes. Is their any way that I
can get my report just to print the second page when their is notes in
this
field.
Click to expand...
Click to expand...
 
Are there subreports involved in this?
If there are no subreports, adding some code should not ask for parameters
twice. The code I provide has no affect on the parameters or report's record
source.

--
Duane Hookom
MS Access MVP
--

horseman said:
Thanks for that. I have tried it but it does not work. I have I
parameter
set to search for between dates. When I put in the code the parameter asks
me
for a start date & end date twice and then shows no records at all

Duane Hookom said:
You can add code to the On Format event of the section that makes the
page
break invisible if the notes field is null.

Me.PgBrkControl.Visible = Len([Notes] & "") >0

--
Duane Hookom
MS Access MVP
--

horseman said:
In my report I have put in a page break, the second page is for notes.
In
some records I do not have to type in any notes. Is their any way
that I
can get my report just to print the second page when their is notes in
this
field.
Click to expand...
Click to expand...
Click to expand...
 
I have put my database on the hard drive and the coding has worked. They my
be something wrong with our network. Anyway I have got it to work and the
database does not have to go onto the network.

Thanks

Duane Hookom said:
Are there subreports involved in this?
If there are no subreports, adding some code should not ask for parameters
twice. The code I provide has no affect on the parameters or report's record
source.

--
Duane Hookom
MS Access MVP
--

horseman said:
Thanks for that. I have tried it but it does not work. I have I
parameter
set to search for between dates. When I put in the code the parameter asks
me
for a start date & end date twice and then shows no records at all

Duane Hookom said:
You can add code to the On Format event of the section that makes the
page
break invisible if the notes field is null.

Me.PgBrkControl.Visible = Len([Notes] & "") >0

--
Duane Hookom
MS Access MVP
--

In my report I have put in a page break, the second page is for notes.
In
some records I do not have to type in any notes. Is their any way
that I
can get my report just to print the second page when their is notes in
this
field.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top