H home70 Registered User. Local time Today, 12:22 Joined Jul 10, 2006 Messages 72 Aug 20, 2006 #1 Is there a way to make a field on a report visible or not depending on the current date?
A Adeptus What's this button do? Local time Tomorrow, 02:52 Joined Aug 2, 2006 Messages 300 Aug 21, 2006 #2 Code: If CheckDate = Date() then Fieldname.Visible = True else Fieldname.Visible = false end if
H home70 Registered User. Local time Today, 12:22 Joined Jul 10, 2006 Messages 72 Aug 26, 2006 #3 Perfect. Thank you Adeptus.
ListO Señor Member Local time Today, 18:22 Joined Feb 2, 2000 Messages 167 Aug 28, 2006 #4 A slightly simpler version of the above is: Fieldname.Visible = CheckDate = Date() In this version, if Date = CheckDate, then Fieldname will be visible, otherwise invisible. Good luck.
A slightly simpler version of the above is: Fieldname.Visible = CheckDate = Date() In this version, if Date = CheckDate, then Fieldname will be visible, otherwise invisible. Good luck.
A Adeptus What's this button do? Local time Tomorrow, 02:52 Joined Aug 2, 2006 Messages 300 Aug 28, 2006 #5 ListO said: A slightly simpler version of the above is: Fieldname.Visible = CheckDate = Date() In this version, if Date = CheckDate, then Fieldname will be visible, otherwise invisible. Good luck. Click to expand... Might need brackets... fieldname.visible = ( checkdate = date() ) I never trust it to resolve in the right order otherwise
ListO said: A slightly simpler version of the above is: Fieldname.Visible = CheckDate = Date() In this version, if Date = CheckDate, then Fieldname will be visible, otherwise invisible. Good luck. Click to expand... Might need brackets... fieldname.visible = ( checkdate = date() ) I never trust it to resolve in the right order otherwise
ListO Señor Member Local time Today, 18:22 Joined Feb 2, 2000 Messages 167 Aug 28, 2006 #6 Have faith. It works left to right unless forced otherwise!