Search results

Your code did the job! Thanks a lot! I just modified it a little to do what I needed: remove the space after the first comma in LastName, FirstName text field and leave other spaces in string Public Function RemoveSpace(ByVal strData As String) As String Dim intPosition As Integer...

Removing space Thanks a lot for your solution! It works to remove all spaces in the text field. But what if I only wanted to remove the space following the comma in LastName, Firstname MiddleName, e.g. Berg, Richard Allen becomes Berg,Richard Allen and not Berg,RichardAllen? Will modifying...

I am trying to remove a space from a text field [Name] in a table called RegText. The text comes in imported from a text file in this form: LastName, FirstName. After executing a function module called RemoveSpace, I was hoping to remove the space after the comma so it now becomes...

Thanks for the tips, Pat. Reason I am using a text field for the dates in my application is that the application imports records from another system which uses dates in mm/dd/yy format. The users are so used to using this format that they expect to type only yy as the year when they use the...

How can I force Access to interpret the date (e.g.) 12/01/29 to mean 12/01/1929, instead of 12/01/2029? And how can I sort correctly on a text date with the two digit year format?

Is there a way to modify the size of the cursor in Access 2000 using VBA?