Need Help with Line Formating in a report

  • Thread starter Thread starter Joe Cilinceon
  • Start date Start date
J

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.
 
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
 
Duane said:
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
Click to expand...

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
 
Did you try my solution? If so, what didn't work?

--
Duane Hookom
MS Access MVP
--

Joe Cilinceon said:
Duane said:
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
Click to expand...

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
Click to expand...
 
Got it from the post in regards to "How to hide blank values?"

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

--
Duane Hookom
MS Access MVP

Joe Cilinceon said:
Duane said:
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
Click to expand...

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
Click to expand...
Click to expand...
 
Back
Top