Weird problem w/ Group Header

I have a memo field in a group header. The qry for the report runs from a
form. All works great. I put my query criteria into the form then hit a
button, the qry runs, the report pulls up. However, I have one memo field
that the data will not always "pull". It pulls into the qry. I can minimize
the report and it is there. It is just not on the report. It is there
sometimes and some times not. I have eliminated the possibility of
truncation. I changed the value to "STOP" and it doesn't show up. Yet is
does show up as a long sentence for another criteria. I know there is
probably more info needed, I'm just stuck to go any further. Like I said.
The data is in the table. The query is pulling the data. It is something to
do with the report. I can't find any differences in why it will populate
sometimes and not others though I know there has to be a difference else it
would be working. Any suggestions are greatly appreciated. Thank you
--
AJ

Are you making sure the record is saved prior to printing?
What do you see if you place the same control source on a text box in the
detail section?
What is the name of the field and the text box?

--
Duane Hookom
Microsoft Access MVP


"AJ" wrote:

I have a memo field in a group header. The qry for the report runs from a
form. All works great. I put my query criteria into the form then hit a
button, the qry runs, the report pulls up. However, I have one memo field
that the data will not always "pull". It pulls into the qry. I can minimize
the report and it is there. It is just not on the report. It is there
sometimes and some times not. I have eliminated the possibility of
truncation. I changed the value to "STOP" and it doesn't show up. Yet is
does show up as a long sentence for another criteria. I know there is
probably more info needed, I'm just stuck to go any further. Like I said.
The data is in the table. The query is pulling the data. It is something to
do with the report. I can't find any differences in why it will populate
sometimes and not others though I know there has to be a difference else it
would be working. Any suggestions are greatly appreciated. Thank you
--
AJ

The record is already saved. The form isn't adding data, just pulling in
this case.
When I move the field to the detail section it shows up. The field name is
"comments". Thank you for any and all help.
--
AJ


"Duane Hookom" wrote:

Are you making sure the record is saved prior to printing?
What do you see if you place the same control source on a text box in the
detail section?
What is the name of the field and the text box?

--
Duane Hookom
Microsoft Access MVP


"AJ" wrote:

I have a memo field in a group header. The qry for the report runs from a
form. All works great. I put my query criteria into the form then hit a
button, the qry runs, the report pulls up. However, I have one memo field
that the data will not always "pull". It pulls into the qry. I can minimize
the report and it is there. It is just not on the report. It is there
sometimes and some times not. I have eliminated the possibility of
truncation. I changed the value to "STOP" and it doesn't show up. Yet is
does show up as a long sentence for another criteria. I know there is
probably more info needed, I'm just stuck to go any further. Like I said.
The data is in the table. The query is pulling the data. It is something to
do with the report. I can't find any differences in why it will populate
sometimes and not others though I know there has to be a difference else it
would be working. Any suggestions are greatly appreciated. Thank you
--
AJ

I just tested a long memo field in a group header that can grow and all of
the text displays. I would try create a new, very simplistic report to see if
it works.

--
Duane Hookom
Microsoft Access MVP


"AJ" wrote:

The record is already saved. The form isn't adding data, just pulling in
this case.
When I move the field to the detail section it shows up. The field name is
"comments". Thank you for any and all help.
--
AJ


"Duane Hookom" wrote:

Are you making sure the record is saved prior to printing?
What do you see if you place the same control source on a text box in the
detail section?
What is the name of the field and the text box?

--
Duane Hookom
Microsoft Access MVP


"AJ" wrote:

I have a memo field in a group header. The qry for the report runs from a
form. All works great. I put my query criteria into the form then hit a
button, the qry runs, the report pulls up. However, I have one memo field
that the data will not always "pull". It pulls into the qry. I can minimize
the report and it is there. It is just not on the report. It is there
sometimes and some times not. I have eliminated the possibility of
truncation. I changed the value to "STOP" and it doesn't show up. Yet is
does show up as a long sentence for another criteria. I know there is
probably more info needed, I'm just stuck to go any further. Like I said.
The data is in the table. The query is pulling the data. It is something to
do with the report. I can't find any differences in why it will populate
sometimes and not others though I know there has to be a difference else it
would be working. Any suggestions are greatly appreciated. Thank you
--
AJ