I need to loop through the contents of a submitted form field and check/change to proper case. The field is an address field.
Example:
User submits this... 1234 main street
I want it to become this... 1234 Main Street
All I have so far is this:
<UCase(Left(Trim(address1),1)) & LCase(Mid(Trim(address1),2,999))>
...which addresses the first word in the sequnce. I'm having trouble figuring how to loop this and get to the 2..3..4... word. Also, the loop needs to ignore numbers.
BTW, I'm using CF 4.5 so a UDF is not an option for me.
Thanks....
Example:
User submits this... 1234 main street
I want it to become this... 1234 Main Street
All I have so far is this:
<UCase(Left(Trim(address1),1)) & LCase(Mid(Trim(address1),2,999))>
...which addresses the first word in the sequnce. I'm having trouble figuring how to loop this and get to the 2..3..4... word. Also, the loop needs to ignore numbers.
BTW, I'm using CF 4.5 so a UDF is not an option for me.
Thanks....