Thanks John. I'd hate to tally how many hours I've spent trying to make the checkbox perform as I'd like it to. It's reassuring to hear I'm not the only one experiencing problems. I can't change the datatype for this field because I'm not the SQL DBA but you can bet I'll remember this when the data specs go out for another project!