The only thing I can think of that may suit your situation is to use text
boxes instead of data labels with a formula to check if the text is null in
the value, if not null show text otherwise show a blank value.
Something like
=iif([Comment1] is null, " ","Title for Comment 1")
as the value in the text box. Labels only show the text in the label so if
you put this in a label, then you will get this as your label, if that
makes any sense.
Another thing to consider is to be sure to set the detail section and all
you text box properties to Can Shrink and also Can Grow to true so if the
entry is long the box can accommodate the data.
If you're into code, you could write a routine to set the visible property
on the labels as the report is built, but since you said you were a
beginner, I am assuming you are not (yet) into code.
Good Luck
Hal
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: [email protected]
AccessDevelopers@ cc
yahoogroups.com
Subject
[AccessDevelopers] Re: Don't want
11/15/2005 05:19 blank fields printing on report
PM
Please respond to
AccessDevelopers@
yahoogroups.com
Well, I would, but I'm not sure that would work. Let me tell you
about the structure of the table. There are the following fields:
Comment1
Comment1Other
Comment1Text
Comment2
Comment2Other
Comment2Text
Comment3
Comment3Other
Comment3Text
There may or may not be data in any of these fields depending on
what the respondent felt toward the options given. I have the
feeling I'm not going to be able to accomodate this on the report,
what I WANT is if Field 1, 4, 6, 8 and 9 have data, then only the
data and the labels for the data print.
--- In [email protected], [EMAIL PROTECTED] wrote:
>
> 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:
[email protected]
>
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
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.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/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/
