Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-29-2006, 05:41 AM   #1
Durien512
Registered User
 
Join Date: Dec 2005
Location: NY,CT,MA
Posts: 61
Thanks: 0
Thanked 1 Time in 1 Post
Durien512 is an unknown quantity at this point
"PAID" background on paid invoice>?

how can i have the letters PAID in red running accross a form if the balance is '0'?????

i been thinking about it and cant even come up with any logic other than

having a invisible "PAID" that if the balance >0 then make visible?
does that make any sense?

and how would i code it?

Thanks!

Durien512 is offline   Reply With Quote
Old 06-29-2006, 06:00 AM   #2
Banana
split with a cherry atop.
 
Join Date: Sep 2005
Posts: 6,315
Thanks: 0
Thanked 90 Times in 72 Posts
Banana is a name known to all Banana is a name known to all Banana is a name known to all Banana is a name known to all Banana is a name known to all Banana is a name known to all
In the "On Format" event of whatever section you want PAID to appear on-

Code:
If me.txtBalance=0 Then me.Paid.Visible=True
and have your Paid object properties Visible=False.
Banana is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Tab Control Background Color flipper Forms 1 03-06-2006 02:52 PM
Not paid by date emdiesse Queries 2 02-14-2006 03:43 PM
form background images afloyd Forms 1 07-17-2002 05:14 AM




All times are GMT -8. The time now is 03:43 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World