[AccessD] Blanks in text box

Only natural.  So now I'm faced with the problem of committing an unnatural
act.  Any ideas?  Programming, that is.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, November 13, 2007 7:58 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Blanks in text box

This does not strike me as surprising, since the same thing happens in the
database itself. You can't store "aaaa   " in a column. Access will trim it.
So it's only natural that it would do the same for its form controls, isn't
it?

A.

On 11/13/07, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
wrote:
>
> if I key in r and then a space the resulting filter is just an r.  
> There are actually four text boxes like that which can add criteria to 
> the row source of the list box.  I do this four times adding Where 
> clauses to the row
> source:
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.15.30/1127 - Release Date: 11/12/2007
9:19 PM