Remove Spaces Between Words And Add Hyphen Copy Other Field Access

[gcoaster]

Hello All

GOAL - I would like to have one text box where I enter a sentence

txtKeywords: Access Is For Smart People Smarter Than I

I would like to create a button when clicked moves txtKeywords into another textbox [txtKeywordscombined] field and removes the spaces between the words and adds hyphens

txtKeywordscombined: Access-Is-For-Smart-People-Smarter-Than-I


Would I use the 'Replace' command in even procedures to do this? Another way? Example?
Thank you!

 

[JHB]

Replace function is the right one to use.

[FONT=Calibri]  Me.txtKeywordscombined = Replace(Me.txtKeywords, " ", "-")
[/FONT]