[AccessD] Blanks in text box

It the text box where I want to have the trailing blanks retained. I'm
setting the filter for the text box in a subroutine that's called from the
Change event of the text box.

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, November 12, 2007 4:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Blanks in text box

What is the "it" that won't accept and retain trailing blanks, Rocky, the
list box, the textbox, the filter, or what?  If you're trapping keystrokes,
make sure you aren't including a Trim in there somewhere.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, November 12, 2007 4:24 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Blanks in text box

Dear List:
 
I am trapping keystrokes in a text box and setting a filter in a list box
based on the current value in the text box.  But it won't accept and retain
trailing blanks.  If my client wants to search on R & R for example, he
presses R and the list box of names is filtered to all those beginning with
R.  if he then presses the space bar, it should show all the name beginning
with R-blank.  But of course, it strips the trailing blank.
 
Is there some trick to getting the trailing blanks to be included in the
string?
 
MTIA
 
Rocky
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
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/1125 - Release Date: 11/11/2007
9:50 PM