If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Weird problem w/ Group Header
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 |
#3
|
|||
|
|||
Weird problem w/ Group Header
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 |
#4
|
|||
|
|||
Weird problem w/ Group Header
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 |
Thread Tools | |
Display Modes | |
|
|