Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Weird problem w/ Group Header

0 views
Skip to first unread message

AJ

unread,
Jan 4, 2010, 8:16:01 PM1/4/10
to
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

Duane Hookom

unread,
Jan 4, 2010, 10:32:01 PM1/4/10
to
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

unread,
Jan 5, 2010, 12:52:01 PM1/5/10
to
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

unread,
Jan 5, 2010, 6:00:01 PM1/5/10
to
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.
0 new messages