Access Report Grey Text
Hi All,I have a report in Microsoft Access 2000 that appears with standardblank font in a print preview and shaded grey font in a printout. Idon't want it to be shaded and can't figure out how it got that way.This report is based on a simple query of the database. It is inlandscape mode, but there's a lot of data and I have the margins set to0.2' on the left and right. It's only a page long.
Create a grouped or summary report. Create a grouped or summary report. Access adds a calculated text box control to the report footer, which creates a grand total. Also, if your report has any grouping levels, Access adds group footers (if not already present) and places the total in each footer. You can save reports in other formats so they'll be viewable outside of Access. This is called exporting a file, and it allows you to view and even modify reports in other formats and programs. Access offers options to save your report as an Excel file, text file, PDF, HTML document, and more. Experiment with the different export options to.
The labels andtext boxes on the report all have a ForeColor property of '0' (black).What am I doing wrong? I've made lots of reports in Access and neverhad this problem!Thanks in advance,Robin. WroteI have a report in Microsoft Access 2000that appears with standard blank font in aprint preview and shaded grey font in a print-out. I don't want it to be shaded and can'tfigure out how it got that way.This report is based on a simple query ofthe database.
It is in landscape mode, butthere's a lot of data and I have the marginsset to 0.2' on the left and right. It's only apage long. The labels and text boxes onthe report all have a ForeColor propertyof '0' (black).None of the settings you mention should cause the black to print as gray.Are you seeing this on any other printing? If so, your black ink cartridgemay be getting low. Have you looked at the advanced settings of the printdialog? Other than the ForeColor setting, I can't think of anything inAccess that might cause this phenomenon.
(But, then, I learn new thingsevery day!)Larry LinsonMicrosoft Access MVP. Hi Larry,Thanks for the response. I did check the printer, and everything else- even other reports in the same database - comes out black. Its justthis report that's grey. I also tried playing with the advancedsettings of the printer with no luck.This is a very large database.
Do you think the report object could becorrupt? Is there a way for me to fix a corrupt report withoutdeleting and rebuilding it?Thanks,RobinLarry Linson wrote: wrote I have a report in Microsoft Access 2000 that appears with standard blank font in a print preview and shaded grey font in a print- out.
I don't want it to be shaded and can't figure out how it got that way. This report is based on a simple query of the database. It is in landscape mode, but there's a lot of data and I have the margins set to 0.2' on the left and right. It's only a page long. The labels and text boxes on the report all have a ForeColor property of '0' (black).None of the settings you mention should cause the black to print as gray.Are you seeing this on any other printing? If so, your black ink cartridgemay be getting low. Have you looked at the advanced settings of the printdialog?
Other than the ForeColor setting, I can't think of anything inAccess that might cause this phenomenon. (But, then, I learn new thingsevery day!)Larry LinsonMicrosoft Access MVP. Wrote:Thanks for the response. I did check the printer, and everything else- even other reports in the same database - comes out black. Its justTo possibly help out with Larry' attempts. You may or may not havechecked the following - forgive me if I sound like I'm underestimatingyour skill, but these would be things I'd look at myself. 8)I ran into something similar once a long time ago (A97) and it was theactual fore color - arrrgh, kills me to write it that way!!!
8) 8) -property. Check the property window of each control; for black, theFore Color property on the Format tab should be 0. Any othercombination could look black on a screen preview, but may or may not beblack when printed.Another thing to check: is this a report you put together? Whether itis or not, go to the code for that form (report design menu, View-Code)and search for any lines that have anything to do with forecolorproperties.
Colours (and other peroperties) of controls can be alteredin the code of a report/form to be quite different from what appears onyour design windows.If none of this works, another thing you could try is copying the reportto a new report in the same mdb and see if that helps.Write back if you're not sure what I'm talking about with any of the above.-Tim^o. Hi Tim,Thanks for the advice. I already checked the ForeColor of all of thereport objects and they're all black.
I created the report and thereisn't any module code behind it.Copying didn't solve the problem - still all grey.I'm going to play with it some more later today. Maybe I'll find thatone little property that's causing this.Thanks for the help,RobinTim Marshall wrote: wrote:Thanks for the response. I did check the printer, and everything else- even other reports in the same database - comes out black. Its justTo possibly help out with Larry' attempts.
Modify, edit, or change a report. When you click the report, Access creates a new, unbound text box. Click the label (just to the left of the new text box),.
You may or may not havechecked the following - forgive me if I sound like I'm underestimatingyour skill, but these would be things I'd look at myself. 8)I ran into something similar once a long time ago (A97) and it was theactual fore color - arrrgh, kills me to write it that way!!! 8) 8) -property. Check the property window of each control; for black, theFore Color property on the Format tab should be 0. Any othercombination could look black on a screen preview, but may or may not beblack when printed.Another thing to check: is this a report you put together?
Whether itis or not, go to the code for that form (report design menu, View-Code)and search for any lines that have anything to do with forecolorproperties. Colours (and other peroperties) of controls can be alteredin the code of a report/form to be quite different from what appears onyour design windows.If none of this works, another thing you could try is copying the reportto a new report in the same mdb and see if that helps.Write back if you're not sure what I'm talking about with any of the above.-Tim^o. I've seen some odd things happen on reports where there are graphics,i.e., embedded image controls. Try adjusting the resolution in theprinter driver and see if the problem goes away. I had one report thatusually filled an 8.5x11 sheet suddenly start to print out on a sizethat would fit on a postcard. Only this report would have a problemand subsequent attempts to print would be normal. The printer involvedwas an HP 2100.
I adjusted the resolution in the driver down from1200dpi to 600dpi and all was well. Try printing your report in draftmode or see if your printer driver allows you to change resolutions tosomething lower. Let us know what happens. Hope this helps!Bruce. Hi Bruce,I think you've hit on something there. I tried to reduce the printerresolution from the Print dialog that pops up when I try to print thereport.
Access Report Grey Text Card
I get a protection fault when I try to get at the printerresolution settings. Any other report in the database behaves normallywhen I try to reduce the printer resolution.I'll look into the cause of this error tomorrow. I'll bet it will leadstraight to the problem. (I would do it tonight, but there arechildren at home that need me to make them dinner!)Thanks for the lead!Robinwrote: I've seen some odd things happen on reports where there are graphics,i.e., embedded image controls. Try adjusting the resolution in theprinter driver and see if the problem goes away.
I had one report thatusually filled an 8.5x11 sheet suddenly start to print out on a sizethat would fit on a postcard. Only this report would have a problemand subsequent attempts to print would be normal. The printer involvedwas an HP 2100.
I adjusted the resolution in the driver down from1200dpi to 600dpi and all was well. Try printing your report in draftmode or see if your printer driver allows you to change resolutions tosomething lower.
Let us know what happens. Hope this helps!Bruce. Hi Bruce,Boy, you're good! That was the problem! I cleaned it up by creating anew report, setting the report properties the same as the old report,and copyng the objects from the old to the new. Now its great!I'm not sure why the problem happened in the first place.
Access Report Grey Text Free
I have twoguesses:1) When I was creating this report, I threw in a sub-report, thendecided to delete it. That might have corrupted the report.2) This database started out in Access 2 and has been convertedthroughout the years. Its also gotten fairly large (35 Mb).At any rate, its all good now. Thanks for the help!Robinwrote: I've seen some odd things happen on reports where there are graphics,i.e., embedded image controls. Try adjusting the resolution in theprinter driver and see if the problem goes away. I had one report thatusually filled an 8.5x11 sheet suddenly start to print out on a sizethat would fit on a postcard.
Only this report would have a problemand subsequent attempts to print would be normal. The printer involvedwas an HP 2100. I adjusted the resolution in the driver down from1200dpi to 600dpi and all was well. Try printing your report in draftmode or see if your printer driver allows you to change resolutions tosomething lower. Let us know what happens. Hope this helps!Bruce.
Access Report Grey Texting
On the far left side of the Home tab you can switch between your Report View and your Layout View. Switch to your Layout View. This will open the Report Layout Tools tab. On the far right side of the Design tab (Under Report Layout Tools) click onProperty Sheet. This will open the Property Sheet dialog box on the right side of the screen.
Click on one of the pages of your report and you should see the Property Sheet dialog box change to show your sheet properties. If the Alternate Background Colorshows something like Background 1, Darker 5%, change it to say No Color. Uncheck Property Sheet, switch back to Report View and you should be set.Good Luck!