By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,476 Members | 889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,476 IT Pros & Developers. It's quick & easy.

Allow spaces at the end of fields

P: n/a
This is probably a frequent question, but I can't find the answer
anywhere.

I'm developing a search page for a form, and since the results change
with each keypress, I need to allow spaces (ie the keyword "joe
bloggs" would go "j", "jo", "joe", "joe ", "joe b" etc.).

Access automatically trims the space off the end, though. Is there an
easy way to disable this, or failing that an acceptable kludge
somebody's willing to share?

Thanks,

Stuart
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I have thought to do this once before and never found a satisfactory
solution. It would be possible to use the KeyPress event to append the
currently typed character using Chr() to the textbox's Text property and
store this in a variable. When you are ready to use the entered text,
reference the variable instead of the control. However, this may become
difficult to handle. You'll need to devise a good way to ignore every
none printable character like TAB, or Shift etc.

Mike Storr
www.veraccess.com
Stuart wrote:
This is probably a frequent question, but I can't find the answer
anywhere.

I'm developing a search page for a form, and since the results change
with each keypress, I need to allow spaces (ie the keyword "joe
bloggs" would go "j", "jo", "joe", "joe ", "joe b" etc.).

Access automatically trims the space off the end, though. Is there an
easy way to disable this, or failing that an acceptable kludge
somebody's willing to share?

Thanks,

Stuart

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.