Prev: how to increase the speed for large datasets?
Next: hi jt
From: jean felix on 29 Mar 2010 15:18


"John Spencer" <spencer(a)chpdm.edu> a �crit dans le message de groupe de
discussion : uKjCHUazKHA.1796(a)TK2MSFTNGP02.phx.gbl...
> 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

First  |  Prev  | 
Pages: 1 2 3
Prev: how to increase the speed for large datasets?
Next: hi jt