Report help please

  • Thread starter SJJ via AccessMonster.com
  • Start date
S

SJJ via AccessMonster.com

hi

i have a report that contain bills of customers.
so when they pay off the bill..i need something to say that the bill is paid
off..something like different colour texts or big tick ( image to appear on
the report) or anything.

can u help me please

thanks a lot

SJJ
 
M

Marshall Barton

SJJ said:
i have a report that contain bills of customers.
so when they pay off the bill..i need something to say that the bill is paid
off..something like different colour texts or big tick ( image to appear on
the report) or anything.
Click to expand...


This might be sufficient. Add a text box to the report in a
fairly large section. Set its BackStyle and BorderStyle to
Transparent and its FontSize to a large size such as 72 and
ForeColor to gray. Use an expression something like:

=IIf(paid condition expression, "Paid", Null)
 
D

Duane Hookom

Since we don't know anything about your data structure or anything else, I
can only suggest you print them out and put a smiley face sticker on them.

If you are storing some value in a table that suggests a specific bill has
been paid, you should provide the information to us.
 
S

SJJ via AccessMonster.com

=IIf(paid condition expression, "Paid", Null)

i just wondering where to put this code..
 
S

SJJ via AccessMonster.com

yes..i have a field called payment and it is a drop down menu contain "payed"
or "billed". if it says "payed" then the report should say "payed" in big
font but if billed then it shouldn't.
 
D

Duane Hookom

You should be able to place your expression in the control source of a text
box. This would assume you have a legitimate boolean expression where you
have "paid condition expression".
=IIf([Payment] = "payed", "Paid", Null)
Your postings have used two different spellings of paid.
 
Top