Conditional Format problem
in [General]
|
From: Bob Vance on 26 Mar 2010 18:13 If tbAdditionCharge is Null and tbAdditionAmount is more than 1 condition should be meet but it does not with this code??? IsNull([tbAdditionCharge]) And [tbAdditionChargeAmount]>0 -- Thanks in advance for any help with this......Bob MS Access 2007 accdb Windows XP Home Edition Ver 5.1 Service Pack 3
From: Sylvain Lafontaine on 26 Mar 2010 18:29 Try replacing the AND with an OR: IsNull([tbAdditionCharge]) OR [tbAdditionChargeAmount] > 0 Also, sometimes, you must use the Is Null operator (with a blank space) instead of the IsNull() function: ([tbAdditionCharge] Is Null) OR [tbAdditionChargeAmount] > 0 -- Sylvain Lafontaine, ing. MVP - Windows Live Platform Blog/web site: http://coding-paparazzi.sylvainlafontaine.com Independent consultant and remote programming for Access and SQL-Server (French) "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message news:OjfvVGTzKHA.2644(a)TK2MSFTNGP04.phx.gbl... > If tbAdditionCharge is Null and tbAdditionAmount is more than 1 condition > should be meet but it does not with this code??? > > IsNull([tbAdditionCharge]) And [tbAdditionChargeAmount]>0 > -- > Thanks in advance for any help with this......Bob > MS Access 2007 accdb > Windows XP Home Edition Ver 5.1 Service Pack 3 > >
From: Sylvain Lafontaine on 26 Mar 2010 18:34 Sorry, I misread your post as I can see now that you are using two differents fields: [bAdditionCharge]and [bAdditionChargeAmount] (to much multi-tasking) so my suggestion about replacing the AND with an OR is not OK but you can still take a look at replacing the IsNull() function with the Is Null operator. Also, you make a mention of [tbAdditionAmount] in your explanation but you have wrote [tbAdditionChargeAmount] in your code snippet. Which one is good? -- Sylvain Lafontaine, ing. MVP - Windows Live Platform Blog/web site: http://coding-paparazzi.sylvainlafontaine.com Independent consultant and remote programming for Access and SQL-Server (French) "Sylvain Lafontaine" <sylvainlafontaine2009(a)yahoo.ca> wrote in message news:OyMVIPTzKHA.3264(a)TK2MSFTNGP06.phx.gbl... > Try replacing the AND with an OR: > > IsNull([tbAdditionCharge]) OR [tbAdditionChargeAmount] > 0 > > Also, sometimes, you must use the Is Null operator (with a blank space) > instead of the IsNull() function: > > ([tbAdditionCharge] Is Null) OR [tbAdditionChargeAmount] > 0 > > -- > Sylvain Lafontaine, ing. > MVP - Windows Live Platform > Blog/web site: http://coding-paparazzi.sylvainlafontaine.com > Independent consultant and remote programming for Access and SQL-Server > (French) > > > "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message > news:OjfvVGTzKHA.2644(a)TK2MSFTNGP04.phx.gbl... >> If tbAdditionCharge is Null and tbAdditionAmount is more than 1 condition >> should be meet but it does not with this code??? >> >> IsNull([tbAdditionCharge]) And [tbAdditionChargeAmount]>0 >> -- >> Thanks in advance for any help with this......Bob >> MS Access 2007 accdb >> Windows XP Home Edition Ver 5.1 Service Pack 3 >> >> > >
From: Bob Vance on 26 Mar 2010 21:16 Thanks Sylvain, but neither code worked of yours , I looked at my first post and it is correctly worded, if tbAdditionCharge is null and tbadditionChargeAmount is more than 0 condition to make background "Red" of tbAdditionCharge Thanks Bob "Sylvain Lafontaine" <sylvainlafontaine2009(a)yahoo.ca> wrote in message news:%23MVO$RTzKHA.5332(a)TK2MSFTNGP02.phx.gbl... > Sorry, I misread your post as I can see now that you are using two > differents fields: [bAdditionCharge]and [bAdditionChargeAmount] (to much > multi-tasking) so my suggestion about replacing the AND with an OR is not > OK but you can still take a look at replacing the IsNull() function with > the Is Null operator. > > Also, you make a mention of [tbAdditionAmount] in your explanation but you > have wrote [tbAdditionChargeAmount] in your code snippet. Which one is > good? > > -- > Sylvain Lafontaine, ing. > MVP - Windows Live Platform > Blog/web site: http://coding-paparazzi.sylvainlafontaine.com > Independent consultant and remote programming for Access and SQL-Server > (French) > > > "Sylvain Lafontaine" <sylvainlafontaine2009(a)yahoo.ca> wrote in message > news:OyMVIPTzKHA.3264(a)TK2MSFTNGP06.phx.gbl... >> Try replacing the AND with an OR: >> >> IsNull([tbAdditionCharge]) OR [tbAdditionChargeAmount] > 0 >> >> Also, sometimes, you must use the Is Null operator (with a blank space) >> instead of the IsNull() function: >> >> ([tbAdditionCharge] Is Null) OR [tbAdditionChargeAmount] > 0 >> >> -- >> Sylvain Lafontaine, ing. >> MVP - Windows Live Platform >> Blog/web site: http://coding-paparazzi.sylvainlafontaine.com >> Independent consultant and remote programming for Access and SQL-Server >> (French) >> >> >> "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message >> news:OjfvVGTzKHA.2644(a)TK2MSFTNGP04.phx.gbl... >>> If tbAdditionCharge is Null and tbAdditionAmount is more than 1 >>> condition should be meet but it does not with this code??? >>> >>> IsNull([tbAdditionCharge]) And [tbAdditionChargeAmount]>0 >>> -- >>> Thanks in advance for any help with this......Bob >>> MS Access 2007 accdb >>> Windows XP Home Edition Ver 5.1 Service Pack 3 >>> >>> >> >> > >
From: John Spencer on 27 Mar 2010 07:59
Just want to confirm you used Expression Is and then entered [tbAdditionCharge] Is Null And [tbAdditionChargeAmount],0 > 0 and both fields (not controls) are available in the record source of the form or report. What field type is tbAdditionCharge? If it is a text field it is possible that it contains a zero-length string instead of null. You might try ([tbAdditionCharge] Is Null or [tbAdditionCharge] = "") And [tbAdditionChargeAmount],0 > 0 John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Bob Vance wrote: > Thanks Sylvain, but neither code worked of yours , I looked at my first post > and it is correctly worded, if tbAdditionCharge is null and > tbadditionChargeAmount is more than 0 condition to make background "Red" of > tbAdditionCharge > Thanks Bob |