data showing in report view not in print preview (2 Viewers)
- Thread starter willigsu
- Start date
Thanks for the response. Have checked the page set up and the text box size and properties. I did partially solve the problem by clicking on each box and " bringing to the front" though nothing was showing in front of it that I could see. Now all of the chrs continue to show in report view, but cut off in print preview. I have actually rotated the text in the box to make a label-could that somehow limit the chrs in the box?
You have Design view and pre view.
If you have too many chrs to fit into the space provided then the print preview will cut them off - I believe.
Just make one of them much bigger and see what result you have.
Labels are not a text box.
If you have too many chrs to fit into the space provided then the print preview will cut them off - I believe.
Just make one of them much bigger and see what result you have.
Labels are not a text box.
rattlesnakes
New member
- Local time
- Today, 12:06
- Joined
- Mar 7, 2013
- Messages
- 1
I had this same problem. All data from a text box appear for each record in report view, but only some data appear in print view (and thus, not in the PDF I'm trying to export).
-CanGrow is set to Yes.
-It doesn't matter how big the text box is.
-The same data (e.g. John & John or something with the same number of letters) will appear for one record but not for another one.
I recreated the text box to fix the problem. I couldn't figure out what was wrong with the existing text box.
-CanGrow is set to Yes.
-It doesn't matter how big the text box is.
-The same data (e.g. John & John or something with the same number of letters) will appear for one record but not for another one.
I recreated the text box to fix the problem. I couldn't figure out what was wrong with the existing text box.
Hello, I was having a similar problem with a report in Access 2013. Records that had the same data in the same fields showed only the first instance of the data in print preview, but not the following instances. Whereas in the Report view, all the data was showing, even if the same data was repeated across multiple records.
Try this:
1. Open the report in design view.
2. Open the properties for the specific field with the issue.
3. On the Format tab, change Hide Duplicates to "No"
This has the negative consequence of repeating data that has multiple sub data, too, but it might be worth it for clarity. Hope this helps!
Emily
Try this:
1. Open the report in design view.
2. Open the properties for the specific field with the issue.
3. On the Format tab, change Hide Duplicates to "No"
This has the negative consequence of repeating data that has multiple sub data, too, but it might be worth it for clarity. Hope this helps!
Emily
justinletteney
New member
- Local time
- Today, 13:06
- Joined
- Jun 17, 2014
- Messages
- 1
I was having the same problem. The Column Width for the Report Header wasn't as wide as the Report so whatever was outside the Column was getting cut off.
I resolved the problem as follows:
From Report Design View goto
Page Setup Tab
Page Layout Group
Page Setup
Columns Tab
Check Same as Detail checkbox
I resolved the problem as follows:
From Report Design View goto
Page Setup Tab
Page Layout Group
Page Setup
Columns Tab
Check Same as Detail checkbox
I had this exact same problem.... it turned out that when I selected Yes on the offending textboxes can grow property there turned out to be a carriage return line feed that were entered into the offending field as I had copied and pasted from Excel.
I got rid of them by running an update query using: Update To: Replace(Replace([myfield],Chr(10),""),Chr(13),"")
I got rid of them by running an update query using: Update To: Replace(Replace([myfield],Chr(10),""),Chr(13),"")
- Local time
- Today, 12:06
- Joined
- Feb 28, 2001
- Messages
- 27,133
Be aware that if you have an OnFormat event it doesn't fire in Print Preview - and, just to be symmetrically a pain in the toches, the OnPrint event doesn't fire in Report View.
And... of COURSE in MicroPain's transfinite wisdom, you can't just copy the OnPrint routine to the OnFormat routine or vice-versa because they have different arguments.
This will be significant if you have a wizard build the report and you ask it to build summary totals in a given section footer.
And... of COURSE in MicroPain's transfinite wisdom, you can't just copy the OnPrint routine to the OnFormat routine or vice-versa because they have different arguments.
This will be significant if you have a wizard build the report and you ask it to build summary totals in a given section footer.
Nothing understandable?~?~~??
- Local time
- Today, 13:06
- Joined
- Feb 19, 2002
- Messages
- 43,213
What does that mean?
Is your text rotated, that seemed to be the original OP's problem? Do you have crlf characters in the text,that also interferes.
isladogs
MVP / VIP
- Local time
- Today, 18:06
- Joined
- Jan 14, 2017
- Messages
- 18,209
6 years on & I've only just seen this thread after it was resurrected.
Anyway, the above statements are incorrect.
In Print Preview both Format and Print events fire. In fact, the Format event fires twice.
In Report View, neither event fires
Its easy to confirm this as I did before replying.
Just add code to show a message box in both the Format and Print events of the report Header, Footer or Detail sections
Code:
Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer)
MsgBox "Hello format"
End Sub
Private Sub ReportHeader_Print(Cancel As Integer, PrintCount As Integer)
MsgBox "Hello Print"
End Sub
