Conditionally Print Controls/Data

  • Thread starter Thread starter MikeC
  • Start date Start date
M

MikeC

Today one of my clients asked me to develop a report that shows current
information about various City government site survey projects. The report
will display up to 65 controls per record!

For each selected record, I have been asked to:

1) Conditionally print *only* the controls that contain data. IOW, exclude
null controls.

2) *Reposition* the controls/data on the report to reduce/minimize the
space they consume.

3) Also, minimize space consumption by setting the Can Grow/Can Shrink
property to "Yes".

I'm tentatively planning to consolidate the control labels and their related
data into a very large unbound text box as a BIG STRING and separate each
paired label/data item using vbTabs. I have not yet figured out how to wrap
the lines. Any tips would be greatly appreciated.

In any case, this report could turn out to be really ugly, but I'm not sure
there are any better alternatives that also satisfy the requirements.

Does anyone have any tips to help me achieve my client's requirements while
minimizing the ugliness of the report?

P.S. I'm cross-posting to microsoft.public.access.reports and
microsoft.public.access.modulesdaovba.
 
MikeC said:
Today one of my clients asked me to develop a report that shows current
information about various City government site survey projects. The report
will display up to 65 controls per record!

For each selected record, I have been asked to:

1) Conditionally print *only* the controls that contain data. IOW, exclude
null controls.

2) *Reposition* the controls/data on the report to reduce/minimize the
space they consume.

3) Also, minimize space consumption by setting the Can Grow/Can Shrink
property to "Yes".

I'm tentatively planning to consolidate the control labels and their related
data into a very large unbound text box as a BIG STRING and separate each
paired label/data item using vbTabs. I have not yet figured out how to wrap
the lines. Any tips would be greatly appreciated.

In any case, this report could turn out to be really ugly, but I'm not sure
there are any better alternatives that also satisfy the requirements.
Click to expand...


vbTab will not operate in a text box. The only control
characters that do function is a text box is the new line
sequence vbCrLf, which is Chr(13) & Chr(10)

You can use the + concatination operator to suppress the
label for null fields. E.g.

=("Phone: " + [Phone]) & (" Ext. " + [PhExt]) & (Chr(13) +
Chr(10) + "Address: " + [Addr]) & . . .
 
Thanks Marsh. That should help.

Marshall Barton said:
MikeC said:
Today one of my clients asked me to develop a report that shows current
information about various City government site survey projects. The
report
will display up to 65 controls per record!

For each selected record, I have been asked to:

1) Conditionally print *only* the controls that contain data. IOW,
exclude
null controls.

2) *Reposition* the controls/data on the report to reduce/minimize the
space they consume.

3) Also, minimize space consumption by setting the Can Grow/Can Shrink
property to "Yes".

I'm tentatively planning to consolidate the control labels and their
related
data into a very large unbound text box as a BIG STRING and separate each
paired label/data item using vbTabs. I have not yet figured out how to
wrap
the lines. Any tips would be greatly appreciated.

In any case, this report could turn out to be really ugly, but I'm not
sure
there are any better alternatives that also satisfy the requirements.
Click to expand...


vbTab will not operate in a text box. The only control
characters that do function is a text box is the new line
sequence vbCrLf, which is Chr(13) & Chr(10)

You can use the + concatination operator to suppress the
label for null fields. E.g.

=("Phone: " + [Phone]) & (" Ext. " + [PhExt]) & (Chr(13) +
Chr(10) + "Address: " + [Addr]) & . . .
Click to expand...
 
Back
Top