Glad it all worked.

On 7/6/2017 11:27 AM, Steven Green wrote:
> Mark.. I did the "two sided box" with the same table, filtered, like you 
> suggested.. wow, so simple :-)
> 
> and the advmatch for the email addresses, with ltrim and rtrim on top of 
> it, seems to work great.. ran it against a table with about 25,000 email 
> addresses, don't disagree with it's conclusions so far
> 
> 
> -- 
> 
> Steven Green
> Myrtle Beach, South Carolina, USA
> 
> http://www.OasisTradingPost.com
> 
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
> 
> "Mark Bannister"  wrote in message 
> news:595295ad$1@pnews.thedbcommunity.com...
> 
> validating email addresses properly is actually pretty messy.  I've got
> an advance match that does a very basic qualification I can dig up.
> 
> I've got a selection form that uses two table frames displaying the same
> table.  There is a checkbox field.  Left tableframe has a range for not
> selected.  Right side has range for selected. SQl query for select all
> deselect.   Is that what you need?
> 
> On 6/27/2017 11:56 AM, Steven Green wrote:
>> a simple process that validates the structure of an email address?
>>
>> a good generic two-sided selection box process? click on a value on 
>> the left to move to the right, select all, unselect all, etc..
>>
>>
>> -- 
>>
>> Steven Green
>> Myrtle Beach, South Carolina, USA
>>
>> http://www.OasisTradingPost.com
>>
>> Collectibles and Memorabilia
>> Vintage Lego Sets and Parts
>> - and Paradox support, too
>>
>>
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>>