Need Help with Line Formating in a report

[Joe Cilinceon]

I'll try to ask this again in the hopes someone has a solution to the
problem. I want to print a list of items, 1 item per line as show below.
Here is where the problem arises if the value of the item in null or 0 then
I don't want that item to print at all. I also don't want the item to force
a carriage return.

Rent: 100.00
Late Fee: 10.00
Adm. Fee: 10.00

or if easier

Rent: 100.00
Late Fee: 10.00
Adm. Fee: 10.00

I have experimented with a couple of methods that combine both the label
text and the value into a single text field then prints the line if the
value isn't nothing. However a problem arises with lining the rows up as a
column. I hope that is clear.

 

[Duane Hookom]

You could consider providing samples with Null or 0 since that is the major
issue with your display.

I would change the labels to text boxes and set their control sources to
something like:
="Rent:" + IIf( Nz([Rent],0)=0, Null, "")
Change the original Rent text box to
=IIf( Nz([Rent],0)=0, Null, [Rent])

Set them both to Can Shrink: Yes

 

[Joe Cilinceon]

You could consider providing samples with Null or 0 since that is the
major issue with your display.

I would change the labels to text boxes and set their control sources
to something like:
="Rent:" + IIf( Nz([Rent],0)=0, Null, "")
Change the original Rent text box to
=IIf( Nz([Rent],0)=0, Null, [Rent])

Set them both to Can Shrink: Yes

Thanks you for answering Duane. Now I'm using a method in 1 report (Payment
Receipt) that combines the charge description and charge amount into a
single text field on the report. If the line is values are null or = 0 it
just doesn't print anything and just moves to the next item. I posted the
code for this in a previous post.

I want to do something similar in that I don't want anything to print if the
value of that item is 0. However it is important that the data lines up in 2
colomns as show below.


Item Name Amount
Rent 100.00
Late Fee 10.00

Hope that is clear

 

[Duane Hookom]

Did you try my solution? If so, what didn't work?

--
Duane Hookom
MS Access MVP
--

You could consider providing samples with Null or 0 since that is the
major issue with your display.

I would change the labels to text boxes and set their control sources
to something like:
="Rent:" + IIf( Nz([Rent],0)=0, Null, "")
Change the original Rent text box to
=IIf( Nz([Rent],0)=0, Null, [Rent])

Set them both to Can Shrink: Yes

Thanks you for answering Duane. Now I'm using a method in 1 report
(Payment Receipt) that combines the charge description and charge amount
into a single text field on the report. If the line is values are null or
= 0 it just doesn't print anything and just moves to the next item. I
posted the code for this in a previous post.

I want to do something similar in that I don't want anything to print if
the value of that item is 0. However it is important that the data lines
up in 2 colomns as show below.


Item Name Amount
Rent 100.00
Late Fee 10.00

Hope that is clear

 

[Joe Cilinceon]

Got it from the post in regards to "How to hide blank values?"

Did you try my solution? If so, what didn't work?

--
Duane Hookom
MS Access MVP

You could consider providing samples with Null or 0 since that is
the major issue with your display.

I would change the labels to text boxes and set their control
sources to something like:
="Rent:" + IIf( Nz([Rent],0)=0, Null, "")
Change the original Rent text box to
=IIf( Nz([Rent],0)=0, Null, [Rent])

Set them both to Can Shrink: Yes

Thanks you for answering Duane. Now I'm using a method in 1 report
(Payment Receipt) that combines the charge description and charge
amount into a single text field on the report. If the line is values
are null or = 0 it just doesn't print anything and just moves to the
next item. I posted the code for this in a previous post.

I want to do something similar in that I don't want anything to
print if the value of that item is 0. However it is important that
the data lines up in 2 colomns as show below.


Item Name Amount
Rent 100.00
Late Fee 10.00

Hope that is clear