[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