Textbox Characters

B

Bill

I would like to eliminate 'periods' or 'spaces' at the end of any text that
is entered into a textbox. Is there any code that would do this? Thanks!
 
D

Doug Robbins - Word MVP

The Trim Function will delete spaces. To remove periods, use


Do While Asc(Right(TextBox1.Text, 1)) = 133
TextBox1.Text = Left(TextBox1.Text, Len(TextBox1.Text) - 1)
Loop


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top