You can also shrink the textboxes to almost a horizontal line, and set the "Can Grow" property to True. That way, no space is taken up if the field is empty.
Tobi -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jones, Glenn P MSG (Ret) FL-ARNG Sent: Wednesday, November 16, 2005 9:26 AM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] Don't want blank fields printing on report Hal, You are on the right track but I think that the fields desired may have information in them or may be blank. I would base my report on a query as you suggested but would put "Is Not Null" in the field where there may be no information. By doing this only the fields with information will print in the report. Glenn P. Jones -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 15 November, 2005 17:16 To: AccessDevelopers@yahoogroups.com Subject: Re: [AccessDevelopers] Don't want blank fields printing on report Base your report on a query that only has he fields you want. Hal McGee Engineering Data Manager Group Engineering - Process and Compliance Seating Products Group B/E Aerospace Winston-Salem, NC "Margaret" <[EMAIL PROTECTED] ahoo.com> To Sent by: AccessDevelopers@yahoogroups.com AccessDevelopers@ cc yahoogroups.com Subject [AccessDevelopers] Don't want blank 11/15/2005 05:05 fields printing on report PM Please respond to AccessDevelopers@ yahoogroups.com I'm sure there is a very easy way to do this...but not being a real strong user of Access, need help!! I am going to print a report but many fields in the table are blank. I don't want those fields referenced on the report at all, just the fields with data. How can I do this? Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access Microsoft access help Microsoft access developer training Microsoft access Microsoft access Microsoft access training course programming tutorial YAHOO! GROUPS LINKS Visit your group "AccessDevelopers" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
