Allow spaces at the end of fields

[Stuart]

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

[Mike Storr]

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