![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
%= CropSentence((Recmostofuser.Fields.Item("country_u sr").Value), 10, "...") % |
#3
| |||
| |||
|
|
On Sat, 1 Jul 2006 17:14:26 +0100, "twocans" <buyme (AT) guinness (DOT) com> wrote: %= CropSentence((Recmostofuser.Fields.Item("country_u sr").Value), 10, "...") % %= Proper(CropSentence((Recmostofuser.Fields.Item("co untry_usr").Value), 10, "...")) % Gary |
#4
| |||
| |||
|
|
Thanks Gary, %= Proper(CropSentence((Recmostofuser.Fields.Item("co untry_usr").Value),10, "...")) % i had tried that earlier but as soon as I apply both then the proper function wont work. i am struggling kenny "Gary White" <reply (AT) newsgroup (DOT) please> wrote in message news:ng9da2tlvlr2dji5r91eno7q2q4cv8g3p3 (AT) 4ax (DOT) com... On Sat, 1 Jul 2006 17:14:26 +0100, "twocans" <buyme (AT) guinness (DOT) com> wrote: %= CropSentence((Recmostofuser.Fields.Item("country_u sr").Value), 10, "...") % %= Proper(CropSentence((Recmostofuser.Fields.Item("co untry_usr").Value), 10, "...")) % Gary |
#5
| |||
| |||
|
|
I take it back it does work, but the proper function needs to be changed, I wanted to have a capital on each word of a sentence not just the first letter. if you have a snippet for that i would be grateful. below is what I have but it will only change the first letter of a sentence. |
#6
| |||
| |||
|
#7
| |||
| |||
|
|
function proper(str) proper = "" aStr = split(str," ") for i = 0 to ubound(aStr) proper = proper & ucase(left(aStr(i),1)) & lcase(right(aStr(i),len(aStr(i))-1)) & " " next proper = rtrim(proper) end function |
![]() |
| Thread Tools | |
| Display Modes | |
| |