change spaces to _

[Help via AccessMonster.com]

Is there a way for access to return what was being input into a text box

I am having trouble with trailing spaces (access text box removes it)
therefore I am thinking to format it to "_", therefore I am still able to
preserve the length

 

[PieterLinden via AccessMonster.com]

Is there a way for access to return what was being input into a text box

I am having trouble with trailing spaces (access text box removes it)
therefore I am thinking to format it to "_", therefore I am still able to
preserve the length

try using Replace()

strInput = Replace(strInput, " ", "_")