[AccessD] Blanks in text box

 So what does the resulting filter look like?  Have you tried replacing
a " " with a Space(1)?

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 5:47 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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