Notes field in a report

[horseman]

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.

 

[Duane Hookom]

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

 

[horseman]

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

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.

 

[Duane Hookom]

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
--

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

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.

 

[horseman]

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

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
--

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

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.