Interesting bug/feature

[David Thompson]

>  > On Jul 7, 2008, at 11:24 PM, Dr. A.S.J. Botenga MD wrote:
>>
>>>  Why not without making a selection
>>>
>>>  field B formulafill ?(A="","hello",B)
>>
>>  Or...
>>
>>  EmptyFill "hello"
>>
>>  Gary
>
>  I am sorry that I missed your mail from 7th July. Therefore a late reply.
>My reaction was based on the solution offered by mr Jim Rea. EmptyFill
>"hello" does not cover the problem, since it are the empty cells in field A
>to be filled in field B.
>
>Allard

That's precisely what EmptyFill does. It's the same as Fill, except 
that it skips over the cells that already have content, and fills the 
empty ones. If you had some reason why those records should be the 
only visible records after it was done, you would select the empty 
records before doing a fill. If different values were to be placed in 
different records, you would use a FormulaFill that tested for empty 
records. If you don't have any particular need to make some of the 
records invisible, and you want to put the same value into every 
empty cell, EmptyFill would be the simplest solution.

Dave