Report help please

  • Thread starter Thread starter SJJ via AccessMonster.com
  • Start date 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
 
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)
 
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.
 
=IIf(paid condition expression, "Paid", Null)

i just wondering where to put this code..
 
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.
 
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.
 
Back
Top