Replacespace with underscore in a text string
Competent Performer
Windows 8 
Access 2010 32bit
I sometimes get a last name with two names not connected by a dash (i.e. Smith-Jones), instead it is entered as "Smith Jones". When I get it from Excel into Access is there a way to replace the space with an underscore in Access? I know I can do it in Excel, but I need that Excel file the way it is for other purposes. Help please.
Moderator
Windows XP Access 2003
LastName =Replace(lastName," ","_") untested see Replace() in Access
Competent Performer
Windows 8 Access 2010 32bit
Worked perfectly.
Keycode for dash/underscore key
SQL String need to use underscore for continuation of line of code
Show text box in a form based on a character within a string in another text box
text string
Posting Permissions
Reply With Quote