Recent content by vlk234

Becoming an expert, IMO, is simply being able to figure out how to do what you want to do. Practice and poking. Experimentation teaches us quite a bit.

Thanks, BNPMike. I actually did think of that. Unfortunately, I inherited the database and was trying to make it work as it was set up. Actually, the name field has four entities. Last Name, First Name, Mid Init, Title... We may end up doing that yet.

Actually, I'm getting a Run-Time Eror '13' Type mismatch when I run the script as is. If I ignore the error, I get a validation violation. I've been playing around with it. I know I'm doing something wrong.

Thanks for the correction. Yeah, I did figure out that I would never get to the last 4 characters. I've only used a few scripts and am still trying to figure all of this out. So far, your script is not leaving the last 4 characters in their original state. Could this be because of...

When I use this in my scrpt For I = 2 To Len(stOneLine) - 4 The last four characters are ignored completely and not returned in their original state. I think we're on the right track though. Thanks for getting me this far.

Thank you, I'll try it!

Just to be difficult, how would I exclude the last 4 characters of a field from being proper cased?

Is there any way to update a partial field in Access. If I have the text: SMITH, JOHN, MD When proper cased, the field looks like this: Smith, John, Md What I need it to look like is: Smith, John, MD Is there any way to replace Md with MD while leaving the original name intact? I've...

I've been staring at this problem for several days now and am so glad to have found this thread, but I am still having a problem. The code shows the correct number of pages, but I'm not getting it to show in the area of the unbound text box on the footer of the report. What am I missing? I...