You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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.